Hi,

We are still looking into this query. As soon as we are able to get anything, we will immediately reply to you.

We apologize for the delay in our response.

Thanks & Regards,

Trainings Team

Hi,

We can able to build the approval based on below option only (attached screenshot for your reference)

We want to know who is an initiator for 1 & 2 leave of approver and How will identity top manager person? 

You can also refer to this document for possible scenanrios: Managing Approval Rules in Oracle HCM with Examples

Thanks & Regards, 

Apps2fusion Trainings Team

Hi Ayman, 

We apoogise for the misinformation and delay in our responses. 

We promise you as soon we are able to get solution from our SME, we will definitely get back to you..

Your patience is very important to us.

Thanks & Regards,

Apps2fusion Training Operations Team

Hi Ayman, 

As promised

The basic query to find the grade of an employee is as below : 

SELECT papf.person_number,

  pgft.name    gradename

FROM   per_all_people_f papf,

      per_all_assignments_m paam,

      per_grades_f pgf,

  per_grades_f_tl pgft

WHERE  papf.person_id = paam.person_id

AND    TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND papf.effective_end_date

AND    paam.primary_assignment_flag = 'Y'

AND    paam.assignment_type = 'E'

AND    paam.effective_latest_change = 'Y'

AND    TRUNC(SYSDATE) BETWEEN paam.effective_start_date AND paam.effective_end_date

AND    paam.grade_id = pgf.grade_id

AND    TRUNC(SYSDATE) BETWEEN pgf.effective_start_date AND pgf.effective_end_date

AND    pgf.grade_id = pgft.grade_id

AND    pgft.language = 'US'

AND    TRUNC(SYSDATE) BETWEEN pgft.effective_start_date AND pgft.effective_end_date

and    papf.person_number = nvl(:personnumber,papf.person_number)

order by papf.person_number asc,pgft.name asc nulls first

Additionally to get the person id of the logged in user, the below expression can be used:

HRC_SESSION_UTIL.GET_USER_PERSONID

Thanks & Regards,

A2f Team