DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PAY_PAYROLLS_F

Line 443: pay_payrolls_f PPF

439: --
440: SELECT number_per_fiscal_year
441: INTO l_number_of_period
442: FROM per_time_period_types TPT,
443: pay_payrolls_f PPF
444: WHERE TPT.period_type = PPF.period_type
445: AND PPF.payroll_id = P_payroll_id
446: AND l_calc_end_date BETWEEN PPF.effective_start_date
447: AND PPF.effective_end_date;