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.JA_CN_PS_SI_BAI_EXPORT_PKG dependencies on HZ_PARTIES

Line 73: HZ_PARTIES HP

69: , CBA.BANK_ACCOUNT_NAME ACCOUNT_NAME
70: , CBA.BANK_ACCOUNT_TYPE ACCOUNT_TYPE
71: , CBA.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUM
72: FROM
73: HZ_PARTIES HP
74: , HZ_ORGANIZATION_PROFILES HOP
75: , HZ_CODE_ASSIGNMENTS HCA -- added for fixing bug# 10268933
76: , CE_BANK_ACCOUNTS CBA
77: WHERE CBA.BANK_ID = HP.PARTY_ID(+)

Line 105: AND HCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

101: )
102: -- added for fixing bug# 10268933 BEGIN --
103: AND HCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
104: AND HCA.CLASS_CODE IN ('BANK', 'CLEARINGHOUSE')
105: AND HCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
106: AND HCA.OWNER_TABLE_ID = HP.PARTY_ID
107: AND ( HCA.END_DATE_ACTIVE IS NULL
108: OR
109: EXTRACT(YEAR FROM HCA.END_DATE_ACTIVE) >= pn_account_year