DBA Data[Home] [Help]

APPS.HR_AU_HOLIDAYS dependencies on PAY_PAYROLLS_F

Line 1912: from pay_payrolls_f p

1908:
1909: cursor c_number_of_periods_per_year (p_payroll_id number
1910: ,p_effective_date date) is
1911: select tpt.number_per_fiscal_year
1912: from pay_payrolls_f p
1913: , per_time_period_types tpt
1914: where p.payroll_id = p_payroll_id
1915: and p_effective_date between p.effective_start_date
1916: and p.effective_end_date