DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PER_ALL_PEOPLE_F

Line 629: from per_all_people_f

625: where paa2.assignment_id = l_asg_id);
626:
627: cursor emp_no is
628: select employee_number
629: from per_all_people_f
630: where person_id = p_person_id;
631:
632: begin
633: if not p_lowest then

Line 2426: l_from := l_from || ' ,per_all_people_f pap

2422: end if;
2423:
2424: if l_person_type is not null
2425: then
2426: l_from := l_from || ' ,per_all_people_f pap
2427: ,per_person_types ppt ';
2428: l_where := l_where || 'and pap.person_id = paf.person_id
2429: and pap.person_type_id = ppt.person_type_id
2430: and ppt.system_person_type = ''EX_EMP'' ';