DBA Data[Home] [Help]

APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 22: popm PAY_ORG_PAYMENT_METHODS_F_PK,

18: IS
19: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,
20: paa PAY_ASSIGNMENT_ACTIONS_N50,
21: ppp PAY_PRE_PAYMENTS_PK,
22: popm PAY_ORG_PAYMENT_METHODS_F_PK,
23: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
24: a PER_ASSIGNMENTS_F_PK,
25: p PER_PEOPLE_F_PK ,
26: oea PAY_EXTERNAL_ACCOUNTS_PK,

Line 41: , pay_org_payment_methods_f popm

37: FROM
38: pay_payroll_actions ppa
39: , pay_assignment_actions paa
40: , pay_pre_payments ppp
41: , pay_org_payment_methods_f popm
42: , pay_personal_payment_methods_f pppm
43: , per_all_assignments_f a
44: , per_all_people_f p
45: , pay_external_accounts oea

Line 90: popm PAY_ORG_PAYMENT_METHODS_F_PK,

86: IS
87: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,
88: paa PAY_ASSIGNMENT_ACTIONS_N50,
89: ppp PAY_PRE_PAYMENTS_PK,
90: popm PAY_ORG_PAYMENT_METHODS_F_PK,
91: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
92: a PER_ASSIGNMENTS_F_PK,
93: p PER_PEOPLE_F_PK ,
94: oea PAY_EXTERNAL_ACCOUNTS_PK,

Line 114: , pay_org_payment_methods_f popm

110: from
111: pay_payroll_actions ppa
112: , pay_assignment_actions paa
113: , pay_pre_payments ppp
114: , pay_org_payment_methods_f popm
115: , pay_personal_payment_methods_f pppm
116: , per_all_assignments_f a -- Bug No 3513042
117: , per_all_people_f p
118: , pay_external_accounts oea

Line 167: popm PAY_ORG_PAYMENT_METHODS_F_PK,

163: IS
164: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,
165: paa PAY_ASSIGNMENT_ACTIONS_N50,
166: ppp PAY_PRE_PAYMENTS_PK,
167: popm PAY_ORG_PAYMENT_METHODS_F_PK,
168: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
169: a PER_ASSIGNMENTS_F_PK,
170: p PER_PEOPLE_F_PK ,
171: oea PAY_EXTERNAL_ACCOUNTS_PK,

Line 191: , pay_org_payment_methods_f popm

187: from
188: pay_payroll_actions ppa
189: , pay_assignment_actions paa
190: , pay_pre_payments ppp
191: , pay_org_payment_methods_f popm
192: , pay_personal_payment_methods_f pppm
193: , per_all_assignments_f a -- Bug No 3513042
194: , per_all_people_f p
195: , pay_external_accounts oea