APPS.POS_SUPP_APPR dependencies on PER_ALL_PEOPLE_F

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

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

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

1457: end if;
1458:
1459: begin
1460: SELECT person_id, full_name into l_person_id,l_full_name FROM (
1461: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
1462: WHERE asg.position_id = l_orig_system_id and trunc(sysdate) between person.effective_start_date
1463: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1464: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1465: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )