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 610: FROM per_all_people_f person

606: l_next_approver_id := l_first_approver_id;
607:
608: SELECT full_name
609: INTO l_next_approver_name
610: FROM per_all_people_f person
611: WHERE person_id = l_first_approver_id
612: --Bug#7207213#This query fetches multiple records so adding a filter
613: and trunc(sysdate) between person.effective_start_date and nvl(person.effective_end_date, trunc(sysdate));
614:

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

616: else
617:
618: /* find the persond id from the position_id*/
619: SELECT person_id, full_name into l_next_approver_id,l_next_approver_name FROM (
620: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
621: WHERE asg.position_id = g_next_approvers(l_approver_index).orig_system_id and trunc(sysdate) between person.effective_start_date
622: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
623: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
624: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

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

1416: l_person_id := l_first_approver_id;
1417:
1418: else
1419: SELECT person_id into l_person_id FROM (
1420: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
1421: WHERE asg.position_id = l_orig_system_id and trunc(sysdate) between person.effective_start_date
1422: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1423: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1424: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 3261: FROM per_all_people_f person

3257: l_next_approver_id := l_first_approver_id;
3258:
3259: SELECT full_name
3260: INTO l_next_approver_name
3261: FROM per_all_people_f person
3262: WHERE person_id = l_first_approver_id
3263: --Bug#7207213#This query fetches multiple records so adding a filter
3264: and trunc(sysdate) between person.effective_start_date and nvl(person.effective_end_date, trunc(sysdate));
3265:

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

3266: else
3267:
3268: /* find the persond id from the position_id*/
3269: SELECT person_id, full_name into l_next_approver_id,l_next_approver_name FROM (
3270: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
3271: WHERE asg.position_id = g_next_approvers(l_approver_index).orig_system_id and trunc(sysdate) between person.effective_start_date
3272: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
3273: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
3274: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )