DBA Data[Home] [Help]

APPS.PAY_SE_TRNA_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 399: per_all_people_f papf

395: FROM per_all_assignments_f paaf,
396: hr_soft_coding_keyflex hsck,
397: hr_organization_units hou,
398: hr_organization_information hoi,
399: per_all_people_f papf
400: WHERE papf.person_id BETWEEN p_start_person AND p_end_person
401: AND g_report_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
402: AND paaf.effective_start_date BETWEEN papf.effective_start_date AND papf.effective_end_date
403: AND papf.person_id = paaf.person_id