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_MAGTAPE_GENERIC

Line 33: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')

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')
36: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
37: ,'RECEIVER_ID=P' ,org.org_information9

Line 35: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYDDD')

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')
36: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
37: ,'RECEIVER_ID=P' ,org.org_information9
38: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
39: ,'FILE_FORMAT=P' ,nvl(org.org_information11, 'AIB')

Line 36: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')

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')
36: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
37: ,'RECEIVER_ID=P' ,org.org_information9
38: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
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')

Line 38: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')

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')
36: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
37: ,'RECEIVER_ID=P' ,org.org_information9
38: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
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

Line 40: ,'EXPIRATION_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')

36: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
37: ,'RECEIVER_ID=P' ,org.org_information9
38: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
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

Line 57: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

53:
54: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464
55: where
56: ppa.payroll_action_id = -- Bug No 3513042
57: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
58: and paa.payroll_action_id = ppa.payroll_action_id
59: and ppp.pre_payment_id = paa.pre_payment_id
60: and oea.external_account_id = popm.external_account_id
61: and popm.org_payment_method_id = ppp.org_payment_method_id

Line 126: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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
128: and paa.payroll_action_id = ppa.payroll_action_id
129: and oea.external_account_id = popm.external_account_id
130: and popm.org_payment_method_id = ppp.org_payment_method_id

Line 203: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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
205: and paa.payroll_action_id = ppa.payroll_action_id
206: and oea.external_account_id = popm.external_account_id
207: and popm.org_payment_method_id = ppp.org_payment_method_id

Line 255: 'VOLUME_ID=P' ,pay_magtape_generic.get_parameter_value('PAYPATH_VOLUME')

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')
258: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
259: ,'RECEIVER_ID=P' ,org.org_information9

Line 257: ,'PROCESSING_DATE=P',to_char(to_date(pay_magtape_generic.get_parameter_value('PROCESSING_DATE'),'YYYY/MM/DD HH24:MI:SS'),'DDMMYYYY')

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')
258: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
259: ,'RECEIVER_ID=P' ,org.org_information9
260: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
261: ,'FILE_FORMAT=P' ,nvl(org.org_information11, 'AIB')

Line 258: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')

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')
258: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
259: ,'RECEIVER_ID=P' ,org.org_information9
260: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
261: ,'FILE_FORMAT=P' ,nvl(org.org_information11, 'AIB')
262: ,'CONSOLIDATION_SET=P',pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET')

Line 260: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')

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')
258: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
259: ,'RECEIVER_ID=P' ,org.org_information9
260: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
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

Line 262: ,'CONSOLIDATION_SET=P',pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET')

258: ,'FILE_NUMBER=P' ,pay_magtape_generic.get_parameter_value('FILE_NUMBER')
259: ,'RECEIVER_ID=P' ,org.org_information9
260: ,'SES_DATE=P' ,to_char(to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS'),'YYMMDD')
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

Line 279: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

275:
276: -- , (select pay_ie_paypath_tape.get_paypathid pathid from dual) paypath -- Bug No 3060464
277: where
278: ppa.payroll_action_id = -- Bug No 3513042
279: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
280: and paa.payroll_action_id = ppa.payroll_action_id
281: and ppp.pre_payment_id = paa.pre_payment_id
282: and oea.external_account_id = popm.external_account_id
283: and popm.org_payment_method_id = ppp.org_payment_method_id

Line 346: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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
348: and paa.payroll_action_id = ppa.payroll_action_id
349: and oea.external_account_id = popm.external_account_id
350: and popm.org_payment_method_id = ppp.org_payment_method_id

Line 426: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

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
428: and paa.payroll_action_id = ppa.payroll_action_id
429: and oea.external_account_id = popm.external_account_id
430: and popm.org_payment_method_id = ppp.org_payment_method_id