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 24: paa PAY_ASSIGNMENT_ACTIONS_N50,

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

Line 43: , pay_assignment_actions paa

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

Line 92: paa PAY_ASSIGNMENT_ACTIONS_N50,

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

Line 116: , pay_assignment_actions paa

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

Line 169: paa PAY_ASSIGNMENT_ACTIONS_N50,

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

Line 193: , pay_assignment_actions paa

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

Line 246: paa PAY_ASSIGNMENT_ACTIONS_N50,

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

Line 265: , pay_assignment_actions paa

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

Line 310: paa PAY_ASSIGNMENT_ACTIONS_N50,

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

Line 336: , pay_assignment_actions paa

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

Line 390: paa PAY_ASSIGNMENT_ACTIONS_N50,

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

Line 416: , pay_assignment_actions paa

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