APPS.CE_VALIDATE_BANKINFO_UPG SQL Statements

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

Line: 12

   select PartyBank.BANK_OR_BRANCH_NUMBER
    From  CE_UPG_BANK_REC   PartyBank
   Where
 	  PartyBank.CE_UPGRADE_ID = Xi_BANK_ID
 	  --PartyBank.source_pk_id = Xi_BANK_ID
     And  PartyBank.BANK_ENTITY_TYPE = 'BANK';

Line: 59

   select PartyBank.BANK_OR_BRANCH_NUMBER
    From  CE_UPG_BANK_REC   PartyBank
   Where
 	  PartyBank.CE_UPGRADE_ID = Xi_BANK_ID
 	  --PartyBank.source_pk_id = Xi_BANK_ID
     And  PartyBank.BANK_ENTITY_TYPE = 'BANK';

Line: 74

   select count(*) into bank_count
    From  CE_UPG_BANK_REC   PartyBank
   Where
 	  PartyBank.CE_UPGRADE_ID = Xi_BANK_ID
 	  --PartyBank.source_pk_id = Xi_BANK_ID
     And  PartyBank.BANK_ENTITY_TYPE = 'BANK';

Line: 233

    SELECT JGZZ_FISCAL_CODE
    FROM   CE_UPG_BANK_REC	--HZ_PARTIES
    WHERE  JGZZ_FISCAL_CODE = p_taxpayer_id
      AND country     = p_country_code;

Line: 299

    SELECT AP.VENDOR_NAME, AP.NUM_1099
    FROM PO_VENDORS AP
    WHERE  (AP.VENDOR_NAME=p_entity_name
    OR  AP.NUM_1099= p_taxpayer_id)
    AND substrb(nvl(AP.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;

Line: 306

    SELECT AR.PARTY_NAME, AR.JGZZ_FISCAL_CODE
    FROM HZ_PARTIES AR
    WHERE  (AR.PARTY_NAME=p_entity_name
    OR  AR.JGZZ_FISCAL_CODE= p_taxpayer_id)
    AND substrb(nvl(AR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code;

Line: 313

    SELECT HR.GLOBAL_ATTRIBUTE8, HR.GLOBAL_ATTRIBUTE11
    FROM HR_LOCATIONS HR
    WHERE  (HR.GLOBAL_ATTRIBUTE8= p_entity_name
    OR  HR.GLOBAL_ATTRIBUTE11= p_taxpayer_id)
    AND substrb(nvl(HR.GLOBAL_ATTRIBUTE_CATEGORY,'XX.XX'),4,2) = p_country_code
    AND HR.LOCATION_USE = 'HR';

Line: 5317

select
      decode(substr(Xi_ACCOUNT_NUMBER ,1,1), '1','Y','2','Y','3','Y','4','N',
      '5','N','6','Y','7','N','8','Y','9','Y','ERR')
into BRANCH_NUMBER
from dual;