DBA Data[Home] [Help]

APPS.PAY_SE_HOLIDAY_PAY_DEBT dependencies on PER_ALL_PEOPLE_F

Line 944: l_person_id per_all_people_f.person_id%TYPE;

940: l_local_unit_id_fetched NUMBER;
941: l_eit_local_unit NUMBER;
942: l_legal_employer_id_fetched NUMBER;
943: -- Temp needed Variables
944: l_person_id per_all_people_f.person_id%TYPE;
945: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
946:
947: -- Temp needed Variables
948:

Line 964: , per_all_people_f pap

960: , pap.national_identifier, pap.person_id, pac.assignment_id
961: , paa.assignment_number, paa.employee_category
962: FROM pay_assignment_actions pac
963: , per_all_assignments_f paa
964: , per_all_people_f pap
965: WHERE pac.assignment_action_id = p_asg_act_id
966: AND paa.assignment_id = pac.assignment_id
967: AND paa.person_id = pap.person_id
968: AND pap.per_information_category = 'SE'