APPS.JA_CN_PS_SI_BAI_EXPORT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 65

SELECT
  CBA.BANK_ACCOUNT_ID       BANK_ACCOUNT_ID
, HOP.BANK_OR_BRANCH_NUMBER BANK_NUMBER
, HP.PARTY_NAME             BANK_NAME
, CBA.BANK_ACCOUNT_NAME     ACCOUNT_NAME
, CBA.BANK_ACCOUNT_TYPE     ACCOUNT_TYPE
, CBA.BANK_ACCOUNT_NUM      BANK_ACCOUNT_NUM
FROM
  HZ_PARTIES               HP
, HZ_ORGANIZATION_PROFILES HOP
, HZ_CODE_ASSIGNMENTS      HCA -- added for fixing bug# 10268933
, CE_BANK_ACCOUNTS         CBA
WHERE CBA.BANK_ID = HP.PARTY_ID(+)
  AND CBA.BANK_ID = HOP.PARTY_ID(+)
  AND HP.PARTY_TYPE = 'ORGANIZATION'
  AND CBA.BANK_ACCOUNT_NUM IS NOT NULL
  AND (CBA.START_DATE IS NULL
       OR
       EXTRACT(YEAR FROM CBA.START_DATE) <= pn_account_year
       ) -- THE ACCOUNTING YEAR PARAMETER
  AND (CBA.END_DATE IS NULL
       OR
       EXTRACT(YEAR FROM CBA.END_DATE) >= pn_account_year
       ) -- THE ACCOUNTING YEAR PARAMETER
  --ONLY THE LATEST BANK PROFILE SHOULD BE EXPORTED
  -- BUG 10110988, ONLY EXPORT THE LATEST BANK INFO
  AND HOP.ORGANIZATION_PROFILE_ID = (
     SELECT MAX(HOP2.ORGANIZATION_PROFILE_ID)
       FROM HZ_ORGANIZATION_PROFILES HOP2
      WHERE CBA.BANK_ID = HOP2.PARTY_ID
      -- the following is commented for fixing bug# 10268933
        /*AND EXTRACT(YEAR FROM HOP2.EFFECTIVE_START_DATE) <= PN_ACCOUNT_YEAR*/
        AND ( HOP2.EFFECTIVE_END_DATE IS NULL
            OR
             EXTRACT(YEAR FROM HOP2.EFFECTIVE_END_DATE) >= pn_account_year
            )
        )
  -- added for fixing bug# 10268933  BEGIN --
  AND HCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
  AND HCA.CLASS_CODE IN ('BANK', 'CLEARINGHOUSE')
  AND HCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
  AND HCA.OWNER_TABLE_ID = HP.PARTY_ID
  AND ( HCA.END_DATE_ACTIVE IS NULL
            OR
             EXTRACT(YEAR FROM HCA.END_DATE_ACTIVE) >= pn_account_year

            )
  -- added for fixing bug# 10268933  END --
  --THE LEGAL ENTITY ID PARAMETER
  AND CBA.ACCOUNT_OWNER_ORG_ID = pn_legal_entity;