APPS.PAY_SE_ALECTA dependencies on PER_ALL_PEOPLE_F

Line 1044: l_person_id per_all_people_f.person_id%TYPE;

1040: l_annual_salary_lo NUMBER :=0; -- Changes 2008/2009
1041: l_annual_salary_fk NUMBER :=0; -- Changes 2008/2009
1042:
1043: -- Temp needed Variables
1044: l_person_id per_all_people_f.person_id%TYPE;
1045: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1046:
1047: -- Temp needed Variables
1048:

Line 1076: ,per_all_people_f pap

1072: ,paa.employee_category
1073: ,paa.effective_start_date
1074: FROM pay_assignment_actions pac
1075: ,per_all_assignments_f paa
1076: ,per_all_people_f pap
1077: WHERE pac.assignment_action_id = p_asg_act_id
1078: AND paa.assignment_id = pac.assignment_id
1079: AND paa.person_id = pap.person_id
1080: AND pap.per_information_category = 'SE'

Line 3052: ,per_all_people_f pap

3048: ,paa.assignment_number
3049: ,paa.effective_start_date
3050: ,pap.date_of_birth
3051: FROM per_all_assignments_f paa
3052: ,per_all_people_f pap
3053: WHERE paa.assignment_id = p_assignment_id
3054: AND paa.person_id = pap.person_id
3055: AND pap.per_information_category = 'SE'
3056: AND p_effective_date BETWEEN pap.effective_start_date

Line 3097: ,per_all_people_f pap

3093: IS
3094: SELECT MONTHS_BETWEEN (g_start_date, pap.date_of_birth) / 12 "YEAR"
3095: ,pap.date_of_birth
3096: FROM per_all_assignments_f paa
3097: ,per_all_people_f pap
3098: WHERE paa.assignment_id = p_assignment_id
3099: AND paa.person_id = pap.person_id
3100: AND pap.per_information_category = 'SE'
3101: AND p_effective_date BETWEEN pap.effective_start_date