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 30: ,'PAYPATH_ID=P' ,pay_ie_archive_detail_pkg.get_paypathid --Bug no. 3813140

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

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

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

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

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

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

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

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

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

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

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