DBA Data[Home] [Help]

APPS.HR_NZ_HOLIDAYS dependencies on PAY_ALL_PAYROLLS_F

Line 3653: ,pay_all_payrolls_f pap

3649: cursor c_retro_start_date(p_effective_date date,
3650: p_payroll_id number) is
3651: select ptp.start_date
3652: from per_time_periods ptp
3653: ,pay_all_payrolls_f pap
3654: where pap.payroll_id = p_payroll_id
3655: and ptp.payroll_id = pap.payroll_id
3656: and (p_effective_date - pap.PAY_DATE_OFFSET) between ptp.start_date and ptp.end_date;
3657: