APPS.PAY_PAYMENT_XML_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 35: pay_action_interlocks pai,

31: SELECT distinct 'EXT_ACT_ID=P', popm.external_account_id
32: FROM pay_payroll_actions ppa,
33: pay_assignment_actions paa,
34: pay_pre_payments ppp,
35: pay_action_interlocks pai,
36: pay_org_payment_methods_f popm
37: WHERE (ppa.payroll_action_id = pay_magtape_generic.get_parameter_value
38: ('TRANSFER_PAYROLL_ACTION_ID')
39: or ppa.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 54: ,pay_action_interlocks pai

50: CURSOR c_bank_asg_actions
51: IS
52: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
53: FROM pay_assignment_actions paa
54: ,pay_action_interlocks pai
55: ,pay_pre_payments ppp
56: ,pay_org_payment_methods_f popm
57: ,pay_assignment_actions paa2
58: ,pay_payroll_actions ppa

Line 84: , pay_action_interlocks pai

80: 'ORG_ID=P',paa.object_id, --should be null
81: 'PRE_PAY_EFF_DATE=P', ppa.effective_date,
82: 'DET_BG_ID=P', ppa.business_group_id
83: FROM pay_pre_payments ppp
84: , pay_action_interlocks pai
85: , pay_assignment_actions paa
86: , pay_assignment_actions paa_chq
87: , pay_payroll_actions ppa
88: , pay_payroll_actions ppa_chq

Line 126: and exists (select 1 from pay_action_interlocks pai,

122: ('TRANSFER_ACT_ID')
123: and paa.object_type='HOU'
124: and ppp.organization_id=paa.object_id
125: and ppp.payroll_action_id= ppa.payroll_action_id
126: and exists (select 1 from pay_action_interlocks pai,
127: pay_assignment_actions paa2
128: where pai.locking_action_id=paa.assignment_action_id
129: and pai.locked_action_id=paa2.assignment_action_id
130: and paa2.payroll_action_id=ppa.payroll_action_id);