APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 23: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,

19: FROM dual;
20:
21: CURSOR CSR_PPH_HEADER_RECORD
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,

Line 42: pay_payroll_actions ppa

38: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
39: ,'FILE_FORMAT=P' ,nvl(org.org_information11, 'AIB')
40: ,'EXPIRATION_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
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

Line 91: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,

87:
88:
89: CURSOR CSR_PPH_CREDIT_RECORD
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,

Line 115: pay_payroll_actions ppa

111: ,'USER_REFERNCE=P', org.org_information10
112: ,'ACC_CREDIT_NAME=P', pea.segment5
113: ,'FILE_FORMAT=P', nvl(org.org_information11, 'AIB')
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

Line 168: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,

164:
165:
166: CURSOR CSR_PPH_CONTRA_RECORD
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,

Line 192: pay_payroll_actions ppa

188: ,'EMPLOYER_ACC_NO=P', oea.segment4
189: ,'ACC_CREDIT_NAME=P', oea.segment5
190: ,'FILE_FORMAT=P', nvl(org.org_information11, 'AIB')
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

Line 245: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,

241:
242:
243: CURSOR CSR_BPH_HEADER_RECORD
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,

Line 264: pay_payroll_actions ppa

260: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
261: ,'FILE_FORMAT=P' ,nvl(org.org_information11, 'AIB')
262: ,'CONSOLIDATION_SET=P',pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET')
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

Line 309: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,

305:
306:
307: CURSOR CSR_BPH_CREDIT_RECORD
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,

Line 335: pay_payroll_actions ppa

331: ,'USER_REFERNCE=P', org.org_information10
332: ,'ACC_CREDIT_NAME=P', pea.segment5
333: ,'FILE_FORMAT=P', nvl(org.org_information11, 'UIB')
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

Line 389: SELECT /*+ ORDERED INDEX (ppa PAY_PAYROLL_ACTIONS_PK,

385: order by 1,2;
386:
387: CURSOR CSR_BPH_CONTRA_RECORD
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,

Line 415: pay_payroll_actions ppa

411: ,'EMPLOYER_ACC_NO=P', oea.segment4
412: ,'ACC_CREDIT_NAME=P', oea.segment5
413: ,'FILE_FORMAT=P', nvl(org.org_information11, 'UIB')
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