DBA Data[Home] [Help]

APPS.PAY_ZA_ACB_TAPE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 95: INDEX (opm PAY_ORG_PAYMENT_METHODS_F_PK)

91: -- ACB Contra-Transaction Header Cursor
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)

Line 119: pay_org_payment_methods_f opm,

115: 'TRANSFER_PAY_METHOD_NAME=P', substr(opm.org_payment_method_name, 1, 80)
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,