APPS.PAY_GB_BACS_TAPE dependencies on PAY_ACTION_INTERLOCKS

Line 259: from pay_action_interlocks pai

255: where paa.payroll_action_id =
256: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
257: and prr.assignment_action_id =
258: (select max(locked_action_id)
259: from pay_action_interlocks pai
260: where ppp.assignment_action_id=pai.locking_action_id
261: )
262: and prrv.run_result_id = prr.run_result_id
263: + decode(pet.element_type_id,0,0,0)

Line 303: from pay_action_interlocks pai

299: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
300: and ppp.pre_payment_id = paa.pre_payment_id
301: and paa2.assignment_action_id =
302: (select max(locked_action_id)
303: from pay_action_interlocks pai
304: where ppp.assignment_action_id=pai.locking_action_id
305: )
306: and not exists (select 1
307: from pay_element_types pet,

Line 348: from pay_action_interlocks pai

344: pay_element_types pet,
345: pay_run_results prr
346: where prr.assignment_action_id =
347: (select max(pai.locked_action_id)
348: from pay_action_interlocks pai
349: where oppp.assignment_action_id=pai.locking_action_id
350: )
351: and prrv.run_result_id = prr.run_result_id
352: + decode(pet.element_type_id,0,0,0)

Line 378: from pay_action_interlocks pai

374: pay_payroll_actions ppa,
375: pay_assignment_actions paa
376: where paa.assignment_action_id =
377: (select max(pai.locked_action_id)
378: from pay_action_interlocks pai
379: where oppp.assignment_action_id=pai.locking_action_id
380: )
381: and paa.payroll_action_id = ppa.payroll_action_id
382: and ppa.payroll_id = ptp.payroll_id

Line 604: from pay_action_interlocks pai

600: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')
601: and prr.assignment_action_id =
602: (select max(locked_action_id)
603: + decode(org.org_payment_method_id,0,0,0)
604: from pay_action_interlocks pai
605: where ppp.assignment_action_id=pai.locking_action_id
606: )
607: and pet.element_type_id = prr.element_type_id
608: and pet.element_name = 'BACS Process Date'

Line 649: from pay_action_interlocks pai

645: pay_magtape_generic.get_parameter_value('BACS_TAPE_BACS_USER_NUMBER')
646: and paa2.assignment_action_id =
647: (select max(locked_action_id)
648: + decode(org.org_payment_method_id,0,0,0)
649: from pay_action_interlocks pai
650: where ppp.assignment_action_id=pai.locking_action_id
651: )
652: and not exists (select 1
653: from pay_element_types pet,

Line 694: from pay_action_interlocks pai

690: pay_element_types pet,
691: pay_run_results prr
692: where prr.assignment_action_id =
693: (select max(pai.locked_action_id)
694: from pay_action_interlocks pai
695: where oppp.assignment_action_id=pai.locking_action_id
696: )
697: and prrv.run_result_id = prr.run_result_id
698: + decode(pet.element_type_id,0,0,0)

Line 724: from pay_action_interlocks pai

720: pay_payroll_actions ppa,
721: pay_assignment_actions paa
722: where paa.assignment_action_id =
723: (select max(pai.locked_action_id)
724: from pay_action_interlocks pai
725: where oppp.assignment_action_id=pai.locking_action_id
726: )
727: and paa.payroll_action_id = ppa.payroll_action_id
728: and ppa.payroll_id = ptp.payroll_id