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_REQ_WF_PVT dependencies on PER_ALL_PEOPLE_F

Line 442: FROM per_all_people_f person

438: l_next_approver_id := l_first_approver_id;
439:
440: SELECT full_name
441: INTO l_next_approver_name
442: FROM per_all_people_f person
443: WHERE person_id = l_first_approver_id
444: --Bug#7207213#This query fetches multiple records so adding a filter
445: and trunc(sysdate) between person.effective_start_date and nvl(person.effective_end_date, trunc(sysdate));
446:

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

448: else
449:
450: /* find the persond id from the position_id*/
451: SELECT person_id, full_name into l_next_approver_id,l_next_approver_name FROM (
452: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
453: WHERE asg.position_id = g_next_approvers(l_approver_index).orig_system_id and trunc(sysdate) between person.effective_start_date
454: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
455: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
456: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 950: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg

946: l_person_id := l_first_approver_id;
947:
948: else
949: SELECT person_id into l_person_id FROM (
950: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
951: WHERE asg.position_id = l_orig_system_id and trunc(sysdate) between person.effective_start_date
952: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
953: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
954: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 2224: FROM per_all_people_f person

2220: l_next_approver_id := l_first_approver_id;
2221:
2222: SELECT full_name
2223: INTO l_next_approver_name
2224: FROM per_all_people_f person
2225: WHERE person_id = l_first_approver_id
2226: --Bug#7207213#This query fetches multiple records so adding a filter
2227: and trunc(sysdate) between person.effective_start_date and nvl(person.effective_end_date, trunc(sysdate));
2228:

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

2229: else
2230:
2231: /* find the persond id from the position_id*/
2232: SELECT person_id, full_name into l_next_approver_id,l_next_approver_name FROM (
2233: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
2234: WHERE asg.position_id = g_next_approvers(l_approver_index).orig_system_id and trunc(sysdate) between person.effective_start_date
2235: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
2236: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
2237: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )