APPS.POR_AME_RCO_WF_PVT dependencies on PER_ALL_PEOPLE_F

Line 412: FROM per_all_people_f person

408: l_next_approver_id := l_first_approver_id;
409:
410: SELECT full_name
411: INTO l_next_approver_name
412: FROM per_all_people_f person
413: WHERE person_id = l_first_approver_id;
414:
415: else
416:

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

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

Line 1681: FROM per_all_people_f person

1677: l_next_approver_id := l_first_approver_id;
1678:
1679: SELECT full_name
1680: INTO l_next_approver_name
1681: FROM per_all_people_f person
1682: WHERE person_id = l_first_approver_id;
1683:
1684: else
1685:

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

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