DBA Data[Home] [Help]

APPS.PAY_CA_PAYROLL_ARCH dependencies on PER_TIME_PERIODS

Line 1206: per_time_periods ptp

1202: ppa.date_earned,
1203: ppa.effective_date
1204: from pay_assignment_actions paa,
1205: pay_payroll_actions ppa,
1206: per_time_periods ptp
1207: where paa.assignment_action_id = cp_run_assignment_action
1208: and ppa.payroll_action_id = paa.payroll_action_id
1209: and ptp.payroll_id = ppa.payroll_id
1210: and ppa.date_earned between ptp.start_date and ptp.end_date;