APPS.PAY_NO_HOLIDAY_PAY dependencies on PER_ALL_PEOPLE_F

Line 118: FROM per_all_people_f papf,

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

Line 253: l_person_id per_all_people_f.person_id%TYPE;

249:
250: -- Function to get the previous employer details.
251: 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
252:
253: l_person_id per_all_people_f.person_id%TYPE;
254:
255: CURSOR csr_person_id IS
256: SELECT paaf.person_id
257: FROM per_all_assignments_f paaf

Line 313: FROM per_all_people_f papf,

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

Line 462: FROM per_all_people_f papf,

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