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_ORGANIZATION_PROFILES

Line 74: , HZ_ORGANIZATION_PROFILES HOP

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(+)
78: AND CBA.BANK_ID = HOP.PARTY_ID(+)

Line 93: FROM HZ_ORGANIZATION_PROFILES HOP2

89: --ONLY THE LATEST BANK PROFILE SHOULD BE EXPORTED
90: -- BUG 10110988, ONLY EXPORT THE LATEST BANK INFO
91: AND HOP.ORGANIZATION_PROFILE_ID = (
92: SELECT MAX(HOP2.ORGANIZATION_PROFILE_ID)
93: FROM HZ_ORGANIZATION_PROFILES HOP2
94: WHERE CBA.BANK_ID = HOP2.PARTY_ID
95: -- the following is commented for fixing bug# 10268933
96: /*AND EXTRACT(YEAR FROM HOP2.EFFECTIVE_START_DATE) <= PN_ACCOUNT_YEAR*/
97: AND ( HOP2.EFFECTIVE_END_DATE IS NULL