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_EXTERNAL_ACCOUNTS

Line 30: oea PAY_EXTERNAL_ACCOUNTS_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 ,
30: oea PAY_EXTERNAL_ACCOUNTS_PK,
31: pea PAY_EXTERNAL_ACCOUNTS_PK)
32: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,hou,org) */
33: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')
34: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140

Line 31: pea PAY_EXTERNAL_ACCOUNTS_PK)

27: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
28: a PER_ASSIGNMENTS_F_PK,
29: p PER_PEOPLE_F_PK ,
30: oea PAY_EXTERNAL_ACCOUNTS_PK,
31: pea PAY_EXTERNAL_ACCOUNTS_PK)
32: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,hou,org) */
33: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')
34: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140
35: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYDDD')

Line 49: , pay_external_accounts oea

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
49: , pay_external_accounts oea
50: , pay_external_accounts pea
51: , hr_organization_units hou
52: , hr_organization_information org
53:

Line 50: , pay_external_accounts pea

46: , pay_personal_payment_methods_f pppm
47: , per_all_assignments_f a
48: , per_all_people_f p
49: , pay_external_accounts oea
50: , pay_external_accounts pea
51: , hr_organization_units hou
52: , hr_organization_information org
53:
54: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464

Line 98: oea PAY_EXTERNAL_ACCOUNTS_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 ,
98: oea PAY_EXTERNAL_ACCOUNTS_PK,
99: pea PAY_EXTERNAL_ACCOUNTS_PK,
100: org HR_ORGANIZATION_INFORMATIO_FK2)
101: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
102: 'TYPE=P', c_credit_type

Line 99: pea PAY_EXTERNAL_ACCOUNTS_PK,

95: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
96: a PER_ASSIGNMENTS_F_PK,
97: p PER_PEOPLE_F_PK ,
98: oea PAY_EXTERNAL_ACCOUNTS_PK,
99: pea PAY_EXTERNAL_ACCOUNTS_PK,
100: org HR_ORGANIZATION_INFORMATIO_FK2)
101: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
102: 'TYPE=P', c_credit_type
103: ,'EMP_NAME=P' , p.full_name

Line 122: , pay_external_accounts oea

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
122: , pay_external_accounts oea
123: , pay_external_accounts pea
124: , hr_organization_information org
125: where ppa.payroll_action_id = -- Bug No 3513042
126: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 123: , pay_external_accounts pea

119: , pay_personal_payment_methods_f pppm
120: , per_all_assignments_f a -- Bug No 3513042
121: , per_all_people_f p
122: , pay_external_accounts oea
123: , pay_external_accounts pea
124: , hr_organization_information org
125: where ppa.payroll_action_id = -- Bug No 3513042
126: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
127: and ppp.pre_payment_id = paa.pre_payment_id

Line 175: oea PAY_EXTERNAL_ACCOUNTS_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 ,
175: oea PAY_EXTERNAL_ACCOUNTS_PK,
176: pea PAY_EXTERNAL_ACCOUNTS_PK,
177: org HR_ORGANIZATION_INFORMATIO_FK2)
178: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
179: 'TYPE=P', 'Z'

Line 176: pea PAY_EXTERNAL_ACCOUNTS_PK,

172: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
173: a PER_ASSIGNMENTS_F_PK,
174: p PER_PEOPLE_F_PK ,
175: oea PAY_EXTERNAL_ACCOUNTS_PK,
176: pea PAY_EXTERNAL_ACCOUNTS_PK,
177: org HR_ORGANIZATION_INFORMATIO_FK2)
178: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
179: 'TYPE=P', 'Z'
180: ,'EMP_NAME=P' , 'null'

Line 199: , pay_external_accounts oea

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
199: , pay_external_accounts oea
200: , pay_external_accounts pea
201: , hr_organization_information org
202: where ppa.payroll_action_id = -- Bug No 3513042
203: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 200: , pay_external_accounts pea

196: , pay_personal_payment_methods_f pppm
197: , per_all_assignments_f a -- Bug No 3513042
198: , per_all_people_f p
199: , pay_external_accounts oea
200: , pay_external_accounts pea
201: , hr_organization_information org
202: where ppa.payroll_action_id = -- Bug No 3513042
203: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
204: and ppp.pre_payment_id = paa.pre_payment_id

Line 252: oea PAY_EXTERNAL_ACCOUNTS_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 ,
252: oea PAY_EXTERNAL_ACCOUNTS_PK,
253: pea PAY_EXTERNAL_ACCOUNTS_PK)
254: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,hou,org) */
255: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')
256: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140

Line 253: pea PAY_EXTERNAL_ACCOUNTS_PK)

249: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
250: a PER_ASSIGNMENTS_F_PK,
251: p PER_PEOPLE_F_PK ,
252: oea PAY_EXTERNAL_ACCOUNTS_PK,
253: pea PAY_EXTERNAL_ACCOUNTS_PK)
254: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,hou,org) */
255: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')
256: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140
257: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'DDMMYYYY')

Line 271: , pay_external_accounts oea

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
271: , pay_external_accounts oea
272: , pay_external_accounts pea
273: , hr_organization_units hou
274: , hr_organization_information org
275:

Line 272: , pay_external_accounts pea

268: , pay_personal_payment_methods_f pppm
269: , per_all_assignments_f a
270: , per_all_people_f p
271: , pay_external_accounts oea
272: , pay_external_accounts pea
273: , hr_organization_units hou
274: , hr_organization_information org
275:
276: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464

Line 316: oea PAY_EXTERNAL_ACCOUNTS_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 ,
316: oea PAY_EXTERNAL_ACCOUNTS_PK,
317: pea PAY_EXTERNAL_ACCOUNTS_PK,
318: org HR_ORGANIZATION_INFORMATIO_FK2)
319: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
320: 'TYPE=P', c_credit_type

Line 317: pea PAY_EXTERNAL_ACCOUNTS_PK,

313: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
314: a PER_ASSIGNMENTS_F_PK,
315: p PER_PEOPLE_F_PK ,
316: oea PAY_EXTERNAL_ACCOUNTS_PK,
317: pea PAY_EXTERNAL_ACCOUNTS_PK,
318: org HR_ORGANIZATION_INFORMATIO_FK2)
319: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
320: 'TYPE=P', c_credit_type
321: ,'EMP_NAME=P' , replace(p.full_name,',','')

Line 342: , pay_external_accounts oea

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
342: , pay_external_accounts oea
343: , pay_external_accounts pea
344: , hr_organization_information org
345: where ppa.payroll_action_id = -- Bug No 3513042
346: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 343: , pay_external_accounts pea

339: , pay_personal_payment_methods_f pppm
340: , per_all_assignments_f a -- Bug No 3513042
341: , per_all_people_f p
342: , pay_external_accounts oea
343: , pay_external_accounts pea
344: , hr_organization_information org
345: where ppa.payroll_action_id = -- Bug No 3513042
346: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
347: and ppp.pre_payment_id = paa.pre_payment_id

Line 396: oea PAY_EXTERNAL_ACCOUNTS_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 ,
396: oea PAY_EXTERNAL_ACCOUNTS_PK,
397: pea PAY_EXTERNAL_ACCOUNTS_PK,
398: org HR_ORGANIZATION_INFORMATIO_FK2)
399: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
400: 'TYPE=P', 'Z'

Line 397: pea PAY_EXTERNAL_ACCOUNTS_PK,

393: pppm PAY_PERSONAL_PAYMENT_METHO_PK,
394: a PER_ASSIGNMENTS_F_PK,
395: p PER_PEOPLE_F_PK ,
396: oea PAY_EXTERNAL_ACCOUNTS_PK,
397: pea PAY_EXTERNAL_ACCOUNTS_PK,
398: org HR_ORGANIZATION_INFORMATIO_FK2)
399: USE_NL(ppa,paa,ppp,popm,pppm,a,p,oea,pea,org) */
400: 'TYPE=P', 'Z'
401: ,'EMP_NAME=P' , 'null'

Line 422: , pay_external_accounts oea

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
422: , pay_external_accounts oea
423: , pay_external_accounts pea
424: , hr_organization_information org
425: where ppa.payroll_action_id = -- Bug No 3513042
426: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

Line 423: , pay_external_accounts pea

419: , pay_personal_payment_methods_f pppm
420: , per_all_assignments_f a -- Bug No 3513042
421: , per_all_people_f p
422: , pay_external_accounts oea
423: , pay_external_accounts pea
424: , hr_organization_information org
425: where ppa.payroll_action_id = -- Bug No 3513042
426: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
427: and ppp.pre_payment_id = paa.pre_payment_id