DBA Data[Home] [Help]

APPS.PER_AE_XDO_REPORT dependencies on PER_ALL_PEOPLE_F

Line 54: ,per_all_people_f people

50: ,dei.dei_information9 place_of_issue
51: ,dei.date_to expiry_date
52: ,assg.assignment_id assignment_id
53: FROM per_all_assignments_f assg
54: ,per_all_people_f people
55: ,hr_document_extra_info dei
56: ,hr_document_types_tl hdtl
57: ,hr_all_organization_units org
58: WHERE assg.person_id = people.person_id

Line 432: ,per_all_people_f people

428: ,dei.issued_at place_of_issue
429: ,dei.date_to expiry_date
430: ,assg.assignment_id assignment_id
431: FROM per_all_assignments_f assg
432: ,per_all_people_f people
433: ,hr_document_extra_info dei
434: ,hr_document_types_tl hdtl
435: ,hr_all_organization_units org
436: WHERE assg.person_id = people.person_id

Line 858: ,per_all_people_f people

854: ,get_lookup_meaning('CONTRACT_TYPE',cont.type) cont_type
855: ,cont.ctr_information1 employment_status
856: ,fnd_date.canonical_to_date(cont.ctr_information2) expiry_date
857: FROM per_all_assignments_f assg
858: ,per_all_people_f people
859: ,per_contracts cont
860: ,per_jobs job
861: ,per_periods_of_service period
862: ,hr_all_organization_units org