DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PER_TIME_PERIOD_TYPES

Line 940: FROM per_time_period_types ptpt

936: ORDER BY paf.effective_end_date DESC, ppp.change_date DESC;
937:
938: CURSOR get_no_per_fiscal_year_csr IS
939: SELECT number_per_fiscal_year
940: FROM per_time_period_types ptpt
941: WHERE period_type = (SELECT ppf.period_type
942: FROM pay_payrolls_f ppf
943: WHERE ppf.payroll_id = p_payroll_id
944: /* Added for Bug 3869766 */