DBA Data[Home] [Help]

APPS.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PER_ALL_PEOPLE_F

Line 637: from per_all_people_f

633: where paa2.assignment_id = l_asg_id);
634:
635: cursor emp_no is
636: select employee_number
637: from per_all_people_f
638: where person_id = p_person_id;
639:
640: begin
641: if not p_lowest then

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

2908: end if;
2909:
2910: if l_person_type is not null
2911: then
2912: l_from := l_from || ' ,per_all_people_f pap
2913: ,per_person_types ppt ';
2914: l_where := l_where || 'and pap.person_id = paf.person_id
2915: and pap.person_type_id = ppt.person_type_id
2916: and ppt.system_person_type = ''EX_EMP'' ';