APPS.PAY_US_MMREF_LOCAL dependencies on PAY_ACTION_PARAMETERS

Line 314: FROM pay_action_parameters

310: WHERE paa.payroll_action_id = cp_payroll_action_id
311: AND paa.action_status = 'E'
312: )
313: AND NOT EXISTS ( SELECT '1'
314: FROM pay_action_parameters
315: WHERE parameter_name = 'FORCE_MAG_REPORT'
316: AND INSTR(parameter_value, 'E') > 0
317: );
318: --Cursor for checking if any of the assignments have been marked for retry

Line 328: FROM pay_action_parameters

324: FROM pay_assignment_actions paa
325: WHERE paa.payroll_action_id = cp_payroll_action_id
326: AND paa.action_status = 'M')
327: AND NOT EXISTS (SELECT '1'
328: FROM pay_action_parameters
329: WHERE parameter_name = 'FORCE_MAG_REPORT'
330: AND INSTR(parameter_value, 'R') > 0
331: );
332: