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
113: AND paaf.effective_end_date
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
303: AND paaf.effective_end_date