APPS.PAY_NO_HOLIDAY_PAY dependencies on PER_ALL_PEOPLE_F

Line 119: FROM per_all_people_f papf,

115:
116: CURSOR csr_person_details IS
117: SELECT papf.per_information16 holiday_entitlement,
118: papf.per_information17 holiday_pay_calc_basis
119: FROM per_all_people_f papf,
120: per_all_assignments_f paaf
121: WHERE paaf.business_group_id = p_business_group_id
122: AND paaf.assignment_id = p_asg_id
123: AND papf.person_id = paaf.person_id

Line 254: l_person_id per_all_people_f.person_id%TYPE;

250:
251: -- Function to get the previous employer details.
252: FUNCTION get_prev_employer_days(p_business_group_id IN NUMBER, p_assg_id IN NUMBER, p_emp_hire_date IN DATE, p_asg_start_date IN DATE) RETURN NUMBER IS
253:
254: l_person_id per_all_people_f.person_id%TYPE;
255:
256: CURSOR csr_person_id IS
257: SELECT paaf.person_id
258: FROM per_all_assignments_f paaf

Line 314: FROM per_all_people_f papf,

310: papf.per_information18 holiday_pay_in_fixed_period,
311: papf.per_information19 hol_pay_over60_in_fix_period,
312: papf.per_information20 holiday_pay_to_be_adjusted,
313: papf.per_information21 res_hol_pay_to_6g_for_over60
314: FROM per_all_people_f papf,
315: per_all_assignments_f paaf
316: WHERE paaf.business_group_id = p_bus_group_id
317: AND paaf.assignment_id = p_assignment_id
318: AND papf.person_id = paaf.person_id

Line 463: FROM per_all_people_f papf,

459:
460: CURSOR csr_person_details IS
461: SELECT
462: papf.per_information13 hol_accrual_entit
463: FROM per_all_people_f papf,
464: per_all_assignments_f paaf
465: WHERE paaf.business_group_id = p_bus_group_id
466: AND paaf.assignment_id = p_assignment_id
467: AND papf.person_id = paaf.person_id