[Home] [Help]
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,
28: a PER_ASSIGNMENTS_F_PK,
29: p PER_PEOPLE_F_PK ,
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
47: , per_all_assignments_f a
48: , per_all_people_f p
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,
96: a PER_ASSIGNMENTS_F_PK,
97: p PER_PEOPLE_F_PK ,
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
120: , per_all_assignments_f a -- Bug No 3513042
121: , per_all_people_f p
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,
173: a PER_ASSIGNMENTS_F_PK,
174: p PER_PEOPLE_F_PK ,
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
197: , per_all_assignments_f a -- Bug No 3513042
198: , per_all_people_f p
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,
250: a PER_ASSIGNMENTS_F_PK,
251: p PER_PEOPLE_F_PK ,
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
269: , per_all_assignments_f a
270: , per_all_people_f p
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,
314: a PER_ASSIGNMENTS_F_PK,
315: p PER_PEOPLE_F_PK ,
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
340: , per_all_assignments_f a -- Bug No 3513042
341: , per_all_people_f p
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,
394: a PER_ASSIGNMENTS_F_PK,
395: p PER_PEOPLE_F_PK ,
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
420: , per_all_assignments_f a -- Bug No 3513042
421: , per_all_people_f p