APPS.PAY_NO_HOLIDAY_PAY dependencies on PER_ALL_ASSIGNMENTS_F

Line 77: FROM per_all_assignments_f paaf

73: 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
74:
75: CURSOR csr_asg IS
76: SELECT MIN(paaf.effective_start_date) effective_start_date
77: FROM per_all_assignments_f paaf
78: WHERE paaf.business_group_id = p_business_group_id
79: AND paaf.assignment_id = p_asg_id
80: AND paaf.assignment_status_type_id = 3;
81:

Line 108: FROM per_all_assignments_f paaf,

104: 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,
105: p_entit_days_over_60 OUT nocopy NUMBER) RETURN NUMBER IS CURSOR csr_assig_details IS
106: SELECT hsck.segment15 holiday_entitlement,
107: hsck.segment16 holiday_pay_calc_basis
108: FROM per_all_assignments_f paaf,
109: hr_soft_coding_keyflex hsck
110: WHERE paaf.business_group_id = p_business_group_id
111: AND paaf.assignment_id = p_asg_id
112: AND p_effective_date BETWEEN paaf.effective_start_date

Line 120: per_all_assignments_f paaf

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

Line 258: FROM per_all_assignments_f paaf

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

Line 298: FROM per_all_assignments_f paaf,

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

Line 315: per_all_assignments_f paaf

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

Line 442: FROM per_all_assignments_f paaf

438:
439: /*Bug 5334894 fix- Added a new function to get the assignment start date*/
440: 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
441: SELECT MIN(paaf.effective_start_date)
442: FROM per_all_assignments_f paaf
443: WHERE paaf.business_group_id = p_business_group_id
444: AND paaf.assignment_id = p_assignment_id
445: AND paaf.assignment_status_type_id = 1;
446:

Line 464: per_all_assignments_f paaf

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