DBA Data[Home] [Help]

APPS.JA_CN_PS_SI_BAI_EXPORT_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 75: , HZ_CODE_ASSIGNMENTS HCA -- added for fixing bug# 10268933

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(+)
79: AND HP.PARTY_TYPE = 'ORGANIZATION'