APPS.PAY_ZA_ACB_TAPE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 96: INDEX (pea PAY_EXTERNAL_ACCOUNTS_PK)

92: --
93: cursor acb_trans_header is
94: select /*+ INDEX (ppa PAY_PAYROLL_ACTIONS_PK)
95: INDEX (opm PAY_ORG_PAYMENT_METHODS_F_PK)
96: INDEX (pea PAY_EXTERNAL_ACCOUNTS_PK)
97: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N50)
98: INDEX (ppp PAY_PRE_PAYMENTS_PK)
99: INDEX (ppm PAY_PERSONAL_PAYMENT_METHO_PK)
100: INDEX (pea2 PAY_EXTERNAL_ACCOUNTS_PK)

Line 100: INDEX (pea2 PAY_EXTERNAL_ACCOUNTS_PK)

96: INDEX (pea PAY_EXTERNAL_ACCOUNTS_PK)
97: INDEX (paa PAY_ASSIGNMENT_ACTIONS_N50)
98: INDEX (ppp PAY_PRE_PAYMENTS_PK)
99: INDEX (ppm PAY_PERSONAL_PAYMENT_METHO_PK)
100: INDEX (pea2 PAY_EXTERNAL_ACCOUNTS_PK)
101: INDEX (paa2 PAY_ASSIGNMENT_ACTIONS_PK)
102: INDEX (ppa2 PAY_PAYROLL_ACTIONS_PK)
103: INDEX (ppf PAY_PAYROLLS_F_PK)
104: INDEX (scl HR_SOFT_CODING_KEYFLEX_PK)

Line 120: pay_external_accounts pea,

116: from pay_payroll_actions ppa,
117: pay_assignment_actions paa,
118: pay_pre_payments ppp,
119: pay_org_payment_methods_f opm,
120: pay_external_accounts pea,
121: pay_personal_payment_methods_f ppm,
122: pay_external_accounts pea2,
123: pay_assignment_actions paa2,
124: pay_payroll_actions ppa2,

Line 122: pay_external_accounts pea2,

118: pay_pre_payments ppp,
119: pay_org_payment_methods_f opm,
120: pay_external_accounts pea,
121: pay_personal_payment_methods_f ppm,
122: pay_external_accounts pea2,
123: pay_assignment_actions paa2,
124: pay_payroll_actions ppa2,
125: pay_all_payrolls_f ppf,
126: hr_soft_coding_keyflex scl,

Line 183: pay_external_accounts pea,

179: 'TRANSFER_ACC_TYPE=P', substr(pea.segment2, 1, 80),
180: 'TRANSFER_TRANS_AMOUNT=P', ppp.value * 100,
181: 'TRANSFER_HOMING_ACC_NAME=P', nvl(upper(substr(pea.segment4, 1, 80)), upper(substr(ppf.last_name, 1, 80)) || ' ' || substr(upper(ppf.first_name), 1, 1))
182: from per_all_people ppf,
183: pay_external_accounts pea,
184: pay_personal_payment_methods ppm,
185: pay_pre_payments ppp,
186: per_all_assignments paf,
187: pay_assignment_actions paa,