APPS.PAY_US_MMREF_REPORTING_MT dependencies on PAY_ACTION_INTERLOCKS

Line 275: pay_action_interlocks AI,

271: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
272: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
273: FROM per_all_people_f PE,
274: per_all_assignments_f SS,
275: pay_action_interlocks AI,
276: pay_assignment_actions AA,
277: pay_payroll_actions PA
278: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
279: ('TRANSFER_PAYROLL_ACTION_ID')

Line 307: pay_action_interlocks AI,

303: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
304: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
305: FROM per_all_people_f PE,
306: per_all_assignments_f SS,
307: pay_action_interlocks AI,
308: pay_assignment_actions AA,
309: pay_assignment_actions paa,
310: pay_payroll_actions PA,
311: ff_archive_items arch,

Line 355: pay_action_interlocks AI,

351: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
352: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
353: FROM per_all_people_f PE,
354: per_all_assignments_f SS,
355: pay_action_interlocks AI,
356: pay_assignment_actions AA,
357: pay_payroll_actions PA
358: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
359: ('TRANSFER_PAYROLL_ACTION_ID')

Line 444: pay_action_interlocks AI,

440: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
441: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID
442: FROM per_all_people_f PE,
443: per_all_assignments_f SS,
444: pay_action_interlocks AI,
445: pay_assignment_actions AA,
446: pay_payroll_actions PA
447: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
448: ('TRANSFER_PAYROLL_ACTION_ID')