DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING_MT dependencies on PAY_ACTION_PARAMETERS

Line 271: FROM pay_action_parameters

267: WHERE paa.payroll_action_id = cp_payroll_action_id
268: AND paa.action_status = 'E'
269: )
270: AND NOT EXISTS ( SELECT '1'
271: FROM pay_action_parameters
272: WHERE parameter_name = 'FORCE_MAG_REPORT'
273: AND INSTR(parameter_value, 'E') > 0
274: );
275: --Cursor for checking if any of the assignments have been marked for retry

Line 285: FROM pay_action_parameters

281: FROM pay_assignment_actions paa
282: WHERE paa.payroll_action_id = cp_payroll_action_id
283: AND paa.action_status = 'M')
284: AND NOT EXISTS (SELECT '1'
285: FROM pay_action_parameters
286: WHERE parameter_name = 'FORCE_MAG_REPORT'
287: AND INSTR(parameter_value, 'R') > 0
288: );
289: