eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IE_PAYPATH_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 20: paa PAY_ASSIGNMENT_ACTIONS_N50,

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,
24: a PER_ASSIGNMENTS_F_PK,

Line 39: , pay_assignment_actions paa

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
43: , per_all_assignments_f a

Line 88: paa PAY_ASSIGNMENT_ACTIONS_N50,

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,
92: a PER_ASSIGNMENTS_F_PK,

Line 112: , pay_assignment_actions paa

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
116: , per_all_assignments_f a -- Bug No 3513042

Line 165: paa PAY_ASSIGNMENT_ACTIONS_N50,

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,
169: a PER_ASSIGNMENTS_F_PK,

Line 189: , pay_assignment_actions paa

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
193: , per_all_assignments_f a -- Bug No 3513042