APPS.PAY_MX_PAYROLL_ARCH dependencies on PER_TIME_PERIODS

Line 3567: per_time_periods ptp

3563: ppa.date_earned,
3564: ppa.effective_date
3565: FROM pay_assignment_actions paa,
3566: pay_payroll_actions ppa,
3567: per_time_periods ptp
3568: WHERE paa.assignment_action_id = cp_run_assignment_action
3569: AND ppa.payroll_action_id = paa.payroll_action_id
3570: AND ptp.payroll_id = ppa.payroll_id
3571: AND ppa.date_earned BETWEEN ptp.start_date AND ptp.end_date;