DBA Data[Home] [Help]

APPS.PER_VIEWS_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 834: FROM per_time_period_types TPT,

830: -- different rate than if it had a full year of payroll periods.
831: --
832: SELECT number_per_fiscal_year
833: INTO l_number_of_period
834: FROM per_time_period_types TPT,
835: pay_payrolls_f PPF
836: WHERE TPT.period_type = PPF.period_type
837: AND PPF.payroll_id = P_payroll_id
838: AND l_calc_end_date BETWEEN PPF.effective_start_date