DBA Data[Home] [Help]

APPS.PAY_NO_HOLIDAY_PAY dependencies on HR_SOFT_CODING_KEYFLEX

Line 108: hr_soft_coding_keyflex hsck

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

Line 298: hr_soft_coding_keyflex hsck

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