174: where act.assignment_id = p_assignment_id
175: and act.action_status in ('C', 'S')
176: and exists
177: (select 'x' 178: from per_time_periods ptp , 179: pay_payroll_actions pct
180: where ptp.time_period_id = p_time_period_id
181: and ptp.time_period_id = pct.time_period_id
182: and pct.effective_date between ptp.start_date and ptp.end_Date
[Home] [Help]