DBA Data[Home] [Help]

APPS.PAY_NO_HOLIDAY_PAY dependencies on HR_SOFT_CODING_KEYFLEX

Line 109: hr_soft_coding_keyflex hsck

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

Line 299: hr_soft_coding_keyflex hsck

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