1916: ),
1917: 16
1918: )
1919: )
1920: FROM pay_assignment_actions paa, pay_payroll_actions ppa
1921: WHERE paa.assignment_id = c_assignment_id
1922: AND ppa.payroll_action_id = paa.payroll_action_id
1923: AND paa.source_action_id IS NOT NULL
1924: AND ppa.effective_date <= c_effective_date
4828: )
4829: IS
4830: SELECT DISTINCT (ptp.end_date) end_date
4831: FROM per_time_periods ptp,
4832: pay_payroll_actions ppa,
4833: pay_assignment_actions paa
4834: WHERE ptp.time_period_id = ppa.time_period_id
4835: AND ppa.effective_date BETWEEN ptp.start_date
4836: AND ptp.end_date