APPS.PAY_SE_ALECTA dependencies on PER_ALL_PEOPLE_F

Line 997: l_person_id per_all_people_f.person_id%TYPE;

993: l_local_unit_id_fetched NUMBER;
994: l_eit_local_unit NUMBER;
995: l_legal_employer_id_fetched NUMBER;
996: -- Temp needed Variables
997: l_person_id per_all_people_f.person_id%TYPE;
998: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
999:
1000: -- Temp needed Variables
1001:

Line 1029: ,per_all_people_f pap

1025: ,paa.employee_category
1026: ,paa.effective_start_date
1027: FROM pay_assignment_actions pac
1028: ,per_all_assignments_f paa
1029: ,per_all_people_f pap
1030: WHERE pac.assignment_action_id = p_asg_act_id
1031: AND paa.assignment_id = pac.assignment_id
1032: AND paa.person_id = pap.person_id
1033: AND pap.per_information_category = 'SE'

Line 2624: ,per_all_people_f pap

2620: ,paa.assignment_number
2621: ,paa.effective_start_date
2622: ,pap.date_of_birth
2623: FROM per_all_assignments_f paa
2624: ,per_all_people_f pap
2625: WHERE paa.assignment_id = p_assignment_id
2626: AND paa.person_id = pap.person_id
2627: AND pap.per_information_category = 'SE'
2628: AND p_effective_date BETWEEN pap.effective_start_date

Line 2669: ,per_all_people_f pap

2665: IS
2666: SELECT MONTHS_BETWEEN (g_start_date, pap.date_of_birth) / 12 "YEAR"
2667: ,pap.date_of_birth
2668: FROM per_all_assignments_f paa
2669: ,per_all_people_f pap
2670: WHERE paa.assignment_id = p_assignment_id
2671: AND paa.person_id = pap.person_id
2672: AND pap.per_information_category = 'SE'
2673: AND p_effective_date BETWEEN pap.effective_start_date