APPS.PAY_US_MMREF_REPORTING_MT dependencies on PAY_ACTION_INTERLOCKS

Line 274: pay_action_interlocks AI,

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

Line 306: pay_action_interlocks AI,

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

Line 354: pay_action_interlocks AI,

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

Line 443: pay_action_interlocks AI,

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