APPS.PAY_GB_BACS_TAPE dependencies on PAY_ACTION_INTERLOCKS

Line 257: from pay_action_interlocks pai

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

Line 301: from pay_action_interlocks pai

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

Line 346: from pay_action_interlocks pai

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

Line 376: from pay_action_interlocks pai

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

Line 602: from pay_action_interlocks pai

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

Line 647: from pay_action_interlocks pai

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

Line 692: from pay_action_interlocks pai

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

Line 722: from pay_action_interlocks pai

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