DBA Data[Home] [Help]

APPS.PAY_SE_STAT_OFFICE_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 434: per_all_people_f pap,

430: '19' || substr(pap.national_identifier,0,6) || substr(pap.national_identifier,8) national_identifier,
431: paa.assignment_number employee_number,
432: paa.assignment_id
433: FROM per_all_assignments_f paa,
434: per_all_people_f pap,
435: HR_SOFT_CODING_KEYFLEX hsc,
436: per_person_types ppt
437: WHERE pap.person_id BETWEEN p_start_person AND p_end_person
438: AND pap.effective_start_date <= p_report_end_date