DBA Data[Home] [Help]

APPS.PAY_US_PTO_ACCRUAL dependencies on PAY_PAYROLLS_F

Line 437: pay_payrolls_f PPF

433: --
434: SELECT number_per_fiscal_year
435: INTO l_number_of_period
436: FROM per_time_period_types TPT,
437: pay_payrolls_f PPF
438: WHERE TPT.period_type = PPF.period_type
439: AND PPF.payroll_id = P_payroll_id
440: AND l_calc_end_date BETWEEN PPF.effective_start_date
441: AND PPF.effective_end_date;