DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on PAY_PAYROLLS_F

Line 690: from pay_payrolls_f p

686:
687: cursor c_number_of_periods_per_year (p_payroll_id number
688: ,p_effective_date date) is
689: select tpt.number_per_fiscal_year
690: from pay_payrolls_f p
691: , per_time_period_types tpt
692: where p.payroll_id = p_payroll_id
693: and p_effective_date between p.effective_start_date
694: and p.effective_end_date