APPS.PAY_NO_HOLIDAY_PAY dependencies on PER_ALL_ASSIGNMENTS_F

Line 76: FROM per_all_assignments_f paaf

72: FUNCTION get_assg_status(p_business_group_id IN NUMBER, p_asg_id IN NUMBER, p_pay_proc_period_start_date IN DATE, p_pay_proc_period_end_date IN DATE) RETURN VARCHAR2 IS
73:
74: CURSOR csr_asg IS
75: SELECT MIN(paaf.effective_start_date) effective_start_date
76: FROM per_all_assignments_f paaf
77: WHERE paaf.business_group_id = p_business_group_id
78: AND paaf.assignment_id = p_asg_id
79: AND paaf.assignment_status_type_id = 3;
80:

Line 107: FROM per_all_assignments_f paaf,

103: FUNCTION get_entitlement_days(p_business_group_id IN NUMBER, p_asg_id IN NUMBER, p_tax_unit_id IN NUMBER, p_effective_date IN DATE, p_above_60 IN VARCHAR2, p_entit_days OUT nocopy NUMBER,
104: p_entit_days_over_60 OUT nocopy NUMBER) RETURN NUMBER IS CURSOR csr_assig_details IS
105: SELECT hsck.segment15 holiday_entitlement,
106: hsck.segment16 holiday_pay_calc_basis
107: FROM per_all_assignments_f paaf,
108: hr_soft_coding_keyflex hsck
109: WHERE paaf.business_group_id = p_business_group_id
110: AND paaf.assignment_id = p_asg_id
111: AND p_effective_date BETWEEN paaf.effective_start_date

Line 119: per_all_assignments_f paaf

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
123: AND p_effective_date BETWEEN papf.effective_start_date

Line 257: FROM per_all_assignments_f paaf

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
258: WHERE paaf.business_group_id = p_business_group_id
259: AND paaf.assignment_id = p_assg_id;
260: /*Bug 5344736 fix - getting the previous employer days */
261: /* Bug 5344736 fix - added condition to check the assignment start year*/

Line 297: FROM per_all_assignments_f paaf,

293: hsck.segment16 holiday_pay_calc_basis,
294: hsck.segment17 holiday_pay_in_fixed_period,
295: hsck.segment18 hol_pay_over60_in_fix_period,
296: hsck.segment19 holiday_pay_to_be_adjusted
297: FROM per_all_assignments_f paaf,
298: hr_soft_coding_keyflex hsck
299: WHERE paaf.business_group_id = p_bus_group_id
300: AND paaf.assignment_id = p_assignment_id
301: AND p_date_earned BETWEEN paaf.effective_start_date

Line 314: per_all_assignments_f paaf

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
318: AND p_date_earned BETWEEN papf.effective_start_date

Line 441: FROM per_all_assignments_f paaf

437:
438: /*Bug 5334894 fix- Added a new function to get the assignment start date*/
439: FUNCTION get_asg_start_date(p_business_group_id IN NUMBER, p_assignment_id IN NUMBER, p_asg_start_date OUT nocopy DATE) RETURN NUMBER IS CURSOR csr_asg_start_date IS
440: SELECT MIN(paaf.effective_start_date)
441: FROM per_all_assignments_f paaf
442: WHERE paaf.business_group_id = p_business_group_id
443: AND paaf.assignment_id = p_assignment_id
444: AND paaf.assignment_status_type_id = 1;
445:

Line 463: per_all_assignments_f paaf

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
467: AND p_date_earned BETWEEN papf.effective_start_date