295: WHERE paa.payroll_action_id = cp_payroll_action_id
296: AND paa.action_status = 'E'
297: )
298: AND NOT EXISTS ( SELECT '1'
299: FROM pay_action_parameters
300: WHERE parameter_name = 'FORCE_MAG_REPORT'
301: AND INSTR(parameter_value, 'E') > 0
302: );
303:
310: FROM pay_assignment_actions paa
311: WHERE paa.payroll_action_id = cp_payroll_action_id
312: AND paa.action_status = 'M')
313: AND NOT EXISTS (SELECT '1'
314: FROM pay_action_parameters
315: WHERE parameter_name = 'FORCE_MAG_REPORT'
316: AND INSTR(parameter_value, 'R') > 0
317: );
318: