DBA Data[Home] [Help]

APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PER_TIME_PERIOD_TYPES

Line 1039: ,per_time_period_types ptp

1035: CURSOR csr_pay_period_count IS
1036: SELECT ptp.number_per_fiscal_year
1037: ,ptp.period_type
1038: FROM pay_payrolls_f ppf
1039: ,per_time_period_types ptp
1040: WHERE payroll_id = p_payroll_id
1041: AND ptp.period_type = ppf.period_type
1042: AND p_calculation_date
1043: BETWEEN ppf.effective_start_date