DBA Data[Home] [Help]

APPS.PAY_SE_SLSA_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 357: FROM per_all_people_f papf,

353: p_effective_start_date DATE,
354: p_effective_end_date DATE
355: ) IS
356: SELECT papf.person_id, paaf.assignment_id, papf.date_of_birth, papf.sex, nvl (hsc.segment9, 100) work_percentage
357: FROM per_all_people_f papf,
358: per_all_assignments_f paaf,
359: hr_soft_coding_keyflex hsc,
360: per_assignment_status_types past,
361: hr_organization_information hoi,

Line 363: per_all_people_f papfs,

359: hr_soft_coding_keyflex hsc,
360: per_assignment_status_types past,
361: hr_organization_information hoi,
362: per_person_types ppt,
363: per_all_people_f papfs,
364: per_all_assignments_f paafs
365: WHERE paaf.person_id = papf.person_id
366: AND paaf.business_group_id = papf.business_group_id
367: AND hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id