DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PER_TIME_PERIODS

Line 6161: FROM per_time_periods ptp

6157: CURSOR csr_period_end_date(p_assignment_action_id NUMBER) IS
6158: SELECT ptp.end_date end_date,
6159: ptp.regular_payment_date regular_payment_date,
6160: ptp.time_period_id time_period_id
6161: FROM per_time_periods ptp
6162: ,pay_payroll_actions ppa
6163: ,pay_assignment_actions paa
6164: WHERE ptp.payroll_id =ppa.payroll_id
6165: AND ppa.payroll_action_id =paa.payroll_action_id