APPS.PAY_US_MMREF_REPORTING1 dependencies on PAY_ACTION_INTERLOCKS

Line 312: pay_action_interlocks AI,

308: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
309: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
310: FROM per_all_people_f PE,
311: per_all_assignments_f SS,
312: pay_action_interlocks AI,
313: pay_assignment_actions AA,
314: pay_payroll_actions PA
315: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
316: ('TRANSFER_PAYROLL_ACTION_ID')

Line 345: pay_action_interlocks AI,

341: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
342: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
343: FROM per_all_people_f PE,
344: per_all_assignments_f SS,
345: pay_action_interlocks AI,
346: pay_assignment_actions AA,
347: pay_assignment_actions paa,
348: pay_payroll_actions PA,
349: ff_archive_items arch,

Line 393: pay_action_interlocks AI,

389: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
390: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
391: FROM per_all_people_f PE,
392: per_all_assignments_f SS,
393: pay_action_interlocks AI,
394: pay_assignment_actions AA,
395: pay_payroll_actions PA
396: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
397: ('TRANSFER_PAYROLL_ACTION_ID')

Line 482: pay_action_interlocks AI,

478: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
479: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID
480: FROM per_all_people_f PE,
481: per_all_assignments_f SS,
482: pay_action_interlocks AI,
483: pay_assignment_actions AA,
484: pay_payroll_actions PA
485: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
486: ('TRANSFER_PAYROLL_ACTION_ID')