APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 26: popm PAY_ORG_PAYMENT_METHODS_F_PK,

22: IS
23: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,
24: paa PAY_ASSIGNMENT_ACTIONS_N50,
25: ppp PAY_PRE_PAYMENTS_PK,
26: popm PAY_ORG_PAYMENT_METHODS_F_PK,
27: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
28: a PER_ASSIGNMENTS_F_PK,
29: p PER_PEOPLE_F_PK ,
30: oea PAY_EXTERNAL_ACCOUNTS_PK,

Line 45: , pay_org_payment_methods_f popm

41: FROM
42: pay_payroll_actions ppa
43: , pay_assignment_actions paa
44: , pay_pre_payments ppp
45: , pay_org_payment_methods_f popm
46: , pay_personal_payment_methods_f pppm
47: , per_all_assignments_f a
48: , per_all_people_f p
49: , pay_external_accounts oea

Line 94: popm PAY_ORG_PAYMENT_METHODS_F_PK,

90: IS
91: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,
92: paa PAY_ASSIGNMENT_ACTIONS_N50,
93: ppp PAY_PRE_PAYMENTS_PK,
94: popm PAY_ORG_PAYMENT_METHODS_F_PK,
95: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
96: a PER_ASSIGNMENTS_F_PK,
97: p PER_PEOPLE_F_PK ,
98: oea PAY_EXTERNAL_ACCOUNTS_PK,

Line 118: , pay_org_payment_methods_f popm

114: from
115: pay_payroll_actions ppa
116: , pay_assignment_actions paa
117: , pay_pre_payments ppp
118: , pay_org_payment_methods_f popm
119: , pay_personal_payment_methods_f pppm
120: , per_all_assignments_f a -- Bug No 3513042
121: , per_all_people_f p
122: , pay_external_accounts oea

Line 171: popm PAY_ORG_PAYMENT_METHODS_F_PK,

167: IS
168: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,
169: paa PAY_ASSIGNMENT_ACTIONS_N50,
170: ppp PAY_PRE_PAYMENTS_PK,
171: popm PAY_ORG_PAYMENT_METHODS_F_PK,
172: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
173: a PER_ASSIGNMENTS_F_PK,
174: p PER_PEOPLE_F_PK ,
175: oea PAY_EXTERNAL_ACCOUNTS_PK,

Line 195: , pay_org_payment_methods_f popm

191: from
192: pay_payroll_actions ppa
193: , pay_assignment_actions paa
194: , pay_pre_payments ppp
195: , pay_org_payment_methods_f popm
196: , pay_personal_payment_methods_f pppm
197: , per_all_assignments_f a -- Bug No 3513042
198: , per_all_people_f p
199: , pay_external_accounts oea

Line 248: popm PAY_ORG_PAYMENT_METHODS_F_PK,

244: IS
245: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,
246: paa PAY_ASSIGNMENT_ACTIONS_N50,
247: ppp PAY_PRE_PAYMENTS_PK,
248: popm PAY_ORG_PAYMENT_METHODS_F_PK,
249: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
250: a PER_ASSIGNMENTS_F_PK,
251: p PER_PEOPLE_F_PK ,
252: oea PAY_EXTERNAL_ACCOUNTS_PK,

Line 267: , pay_org_payment_methods_f popm

263: FROM
264: pay_payroll_actions ppa
265: , pay_assignment_actions paa
266: , pay_pre_payments ppp
267: , pay_org_payment_methods_f popm
268: , pay_personal_payment_methods_f pppm
269: , per_all_assignments_f a
270: , per_all_people_f p
271: , pay_external_accounts oea

Line 312: popm PAY_ORG_PAYMENT_METHODS_F_PK,

308: IS
309: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,
310: paa PAY_ASSIGNMENT_ACTIONS_N50,
311: ppp PAY_PRE_PAYMENTS_PK,
312: popm PAY_ORG_PAYMENT_METHODS_F_PK,
313: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
314: a PER_ASSIGNMENTS_F_PK,
315: p PER_PEOPLE_F_PK ,
316: oea PAY_EXTERNAL_ACCOUNTS_PK,

Line 338: , pay_org_payment_methods_f popm

334: from
335: pay_payroll_actions ppa
336: , pay_assignment_actions paa
337: , pay_pre_payments ppp
338: , pay_org_payment_methods_f popm
339: , pay_personal_payment_methods_f pppm
340: , per_all_assignments_f a -- Bug No 3513042
341: , per_all_people_f p
342: , pay_external_accounts oea

Line 392: popm PAY_ORG_PAYMENT_METHODS_F_PK,

388: IS
389: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,
390: paa PAY_ASSIGNMENT_ACTIONS_N50,
391: ppp PAY_PRE_PAYMENTS_PK,
392: popm PAY_ORG_PAYMENT_METHODS_F_PK,
393: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
394: a PER_ASSIGNMENTS_F_PK,
395: p PER_PEOPLE_F_PK ,
396: oea PAY_EXTERNAL_ACCOUNTS_PK,

Line 418: , pay_org_payment_methods_f popm

414: from
415: pay_payroll_actions ppa
416: , pay_assignment_actions paa
417: , pay_pre_payments ppp
418: , pay_org_payment_methods_f popm
419: , pay_personal_payment_methods_f pppm
420: , per_all_assignments_f a -- Bug No 3513042
421: , per_all_people_f p
422: , pay_external_accounts oea