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
183: and act.payroll_action_id = pct.payroll_action_id