[Home] [Help]
17: CURSOR CSR_PPH_HEADER_RECORD
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 ,
36: ,'EXPIRATION_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
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
85: CURSOR CSR_PPH_CREDIT_RECORD
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 ,
109: ,'FILE_FORMAT=P', nvl(org.org_information11, 'AIB')
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
162: CURSOR CSR_PPH_CONTRA_RECORD
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 ,
186: ,'FILE_FORMAT=P', nvl(org.org_information11, 'AIB')
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