APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_PAYROLL_ACTIONS

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

15: FROM dual;
16:
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,

Line 38: pay_payroll_actions ppa

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

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

83:
84:
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,

Line 111: pay_payroll_actions ppa

107: ,'USER_REFERNCE=P', org.org_information10
108: ,'ACC_CREDIT_NAME=P', pea.segment5
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

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

160:
161:
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,

Line 188: pay_payroll_actions ppa

184: ,'EMPLOYER_ACC_NO=P', oea.segment4
185: ,'ACC_CREDIT_NAME=P', oea.segment5
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