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_IE_ARCHIVE_DETAIL_PKG

Line 34: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140

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

Line 79: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid, pay_ie_archive_detail_pkg.get_paypathid)

75: and org.organization_id = hou.organization_id
76: and pppm.business_group_id = hou.business_group_id
77: and popm.business_group_id = hou.business_group_id
78: -- Added for bug fix 5696117
79: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid, pay_ie_archive_detail_pkg.get_paypathid)
80: in (org.org_information8,'Error',' ')
81: and rownum < 2;
82:
83: /* and (org.org_information8 = pay_ie_paypath_tape.g_pathid --Bug no. 3813140

Line 144: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,

140: and ppa.effective_date between p.effective_start_date and p.effective_end_date
141: and org.organization_id (+) = p.business_group_id
142: and org.org_information_context(+) = 'IE_PAYPATH_INFORMATION'
143: -- Added for bug fix 5696117
144: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,
145: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')
146:
147: /*and (org.org_information8= pay_ie_paypath_tape.g_pathid
148: or ' '=pay_ie_paypath_tape.g_pathid) --Bug No 3086034*/

Line 145: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')

141: and org.organization_id (+) = p.business_group_id
142: and org.org_information_context(+) = 'IE_PAYPATH_INFORMATION'
143: -- Added for bug fix 5696117
144: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,
145: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')
146:
147: /*and (org.org_information8= pay_ie_paypath_tape.g_pathid
148: or ' '=pay_ie_paypath_tape.g_pathid) --Bug No 3086034*/
149: union all

Line 221: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,

217: and ppa.effective_date between p.effective_start_date and p.effective_end_date
218: and org.organization_id (+) = p.business_group_id
219: and org.org_information_context(+) = 'IE_PAYPATH_INFORMATION'
220: -- Added for bug fix 5696117
221: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,
222: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')
223:
224: /* and (org.org_information8= pay_ie_paypath_tape.g_pathid
225: or ' '=pay_ie_paypath_tape.g_pathid) --Bug No 3086034*/

Line 222: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')

218: and org.organization_id (+) = p.business_group_id
219: and org.org_information_context(+) = 'IE_PAYPATH_INFORMATION'
220: -- Added for bug fix 5696117
221: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,
222: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')
223:
224: /* and (org.org_information8= pay_ie_paypath_tape.g_pathid
225: or ' '=pay_ie_paypath_tape.g_pathid) --Bug No 3086034*/
226: group by 'TYPE=P', 'Z'

Line 256: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140

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

Line 301: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid, pay_ie_archive_detail_pkg.get_paypathid)

297: and org.organization_id = hou.organization_id
298: and pppm.business_group_id = hou.business_group_id
299: and popm.business_group_id = hou.business_group_id
300: -- Added for bug fix 5696117
301: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid, pay_ie_archive_detail_pkg.get_paypathid)
302: in (org.org_information8,'Error',' ')
303: and rownum < 2;
304:
305:

Line 364: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,

360: and ppa.effective_date between p.effective_start_date and p.effective_end_date
361: and org.organization_id (+) = p.business_group_id
362: and org.org_information_context(+) = 'IE_PAYPATH_INFORMATION'
363: -- Added for bug fix 5696117
364: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,
365: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')
366:
367: /*and (org.org_information8= pay_ie_paypath_tape.g_pathid
368: or ' '=pay_ie_paypath_tape.g_pathid) --Bug No 3086034*/

Line 365: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')

361: and org.organization_id (+) = p.business_group_id
362: and org.org_information_context(+) = 'IE_PAYPATH_INFORMATION'
363: -- Added for bug fix 5696117
364: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,
365: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')
366:
367: /*and (org.org_information8= pay_ie_paypath_tape.g_pathid
368: or ' '=pay_ie_paypath_tape.g_pathid) --Bug No 3086034*/
369: union all

Line 444: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,

440: and ppa.effective_date between p.effective_start_date and p.effective_end_date
441: and org.organization_id (+) = p.business_group_id
442: and org.org_information_context(+) = 'IE_PAYPATH_INFORMATION'
443: -- Added for bug fix 5696117
444: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,
445: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')
446:
447: /* and (org.org_information8= pay_ie_paypath_tape.g_pathid
448: or ' '=pay_ie_paypath_tape.g_pathid) --Bug No 3086034*/

Line 445: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')

441: and org.organization_id (+) = p.business_group_id
442: and org.org_information_context(+) = 'IE_PAYPATH_INFORMATION'
443: -- Added for bug fix 5696117
444: and decode (org.org_information8,' ', pay_ie_archive_detail_pkg.get_paypathid,
445: pay_ie_archive_detail_pkg.get_paypathid) in (org.org_information8,' ')
446:
447: /* and (org.org_information8= pay_ie_paypath_tape.g_pathid
448: or ' '=pay_ie_paypath_tape.g_pathid) --Bug No 3086034*/
449: group by 'TYPE=P', 'Z'