eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POR_AME_RCO_WF_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 420: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg

416: else
417:
418: /* find the persond id from the position_id*/
419: SELECT person_id, full_name into l_next_approver_id,l_next_approver_name FROM (
420: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
421: WHERE asg.position_id = g_next_approvers(l_approver_index).orig_system_id and trunc(sysdate) between person.effective_start_date
422: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
423: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
424: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 1690: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg

1686: else
1687:
1688: /* find the persond id from the position_id*/
1689: SELECT person_id, full_name into l_next_approver_id,l_next_approver_name FROM (
1690: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
1691: WHERE asg.position_id = g_next_approvers(l_approver_index).orig_system_id and trunc(sysdate) between person.effective_start_date
1692: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1693: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1694: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )