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.CE_VALIDATE_BANKINFO SQL Statements

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

Line: 15


   select OrgProfileBank.BANK_OR_BRANCH_NUMBER
    From  HZ_PARTIES   PartyBank,
    HZ_ORGANIZATION_PROFILES   OrgProfileBank,
    HZ_CODE_ASSIGNMENTS   CABank
   Where
      PartyBank.party_id = Xi_BANK_ID
     and  PartyBank.PARTY_TYPE = 'ORGANIZATION'
     and  PartyBank.status = 'A'
     And     PartyBank.PARTY_ID = OrgProfileBank.PARTY_ID
     and   sysdate between trunc(OrgProfileBank.EFFECTIVE_START_DATE)
                and nvl(trunc(OrgProfileBank.EFFECTIVE_END_DATE),sysdate)
     And     CABank.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
     And     CABank.CLASS_CODE = 'BANK'
     And     CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'
     And     CABank.OWNER_TABLE_ID = PartyBank.PARTY_ID
     And     nvl(CABank.status, 'A') = 'A';

Line: 161


        SELECT count(*) INTO bank_count
        FROM   HZ_PARTIES   PartyBank,
               HZ_ORGANIZATION_PROFILES   OrgProfileBank,
               HZ_CODE_ASSIGNMENTS   CABank
        WHERE
               PartyBank.party_id = Xi_BANK_ID
          AND  PartyBank.PARTY_TYPE = 'ORGANIZATION'
          AND  PartyBank.status = 'A'
          AND  PartyBank.PARTY_ID = OrgProfileBank.PARTY_ID
          AND  sysdate BETWEEN trunc(OrgProfileBank.EFFECTIVE_START_DATE)
               AND nvl(trunc(OrgProfileBank.EFFECTIVE_END_DATE),sysdate)
          AND  CABank.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
          AND  CABank.CLASS_CODE = 'BANK'
          AND  CABank.OWNER_TABLE_NAME = 'HZ_PARTIES'
          AND  CABank.OWNER_TABLE_ID = PartyBank.PARTY_ID
          AND  nvl(CABank.status, 'A') = 'A';

Line: 333


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

Line: 403


    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: 411


    SELECT AR.CUSTOMER_NAME, AR.JGZZ_FISCAL_CODE
    FROM RA_CUSTOMERS AR
    WHERE  (AR.CUSTOMER_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: 420


    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: 427


    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: 668


select count(*) into temp_name
From    HZ_PARTIES              BankParty,
        HZ_PARTIES              BranchParty,
        HZ_ORGANIZATION_PROFILES        BankOrgProfile,
        HZ_ORGANIZATION_PROFILES        BranchOrgProfile,
        HZ_RELATIONSHIPS            BRRel,
        HZ_CODE_ASSIGNMENTS         BankCA,
        HZ_CODE_ASSIGNMENTS         BranchCA
Where   BankParty.PARTY_TYPE = 'ORGANIZATION'
And     BankParty.status = 'A'
And     BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
And     SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
        and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
And     BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
And     BankCA.CLASS_CODE = 'BANK'
And     BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
And     BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
And     NVL(BankCA.STATUS, 'A') = 'A'
And     BranchParty.PARTY_TYPE(+) = 'ORGANIZATION'
And     BranchParty.status(+) = 'A'
And     BranchOrgProfile.PARTY_ID(+) = BranchParty.PARTY_ID
And     SYSDATE between TRUNC(BranchOrgProfile.effective_start_date(+))
        and NVL(TRUNC(BranchOrgProfile.effective_end_date(+)), SYSDATE+1)
And     BranchCA.CLASS_CATEGORY(+) = 'BANK_INSTITUTION_TYPE'
And     BranchCA.CLASS_CODE(+) = 'BANK_BRANCH'
And     BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
And     BranchCA.OWNER_TABLE_ID(+) = BranchParty.PARTY_ID
And     NVL(BranchCA.STATUS(+), 'A') = 'A'
And     BRRel.OBJECT_ID(+) = BankParty.PARTY_ID
And     BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID
And     BRRel.RELATIONSHIP_TYPE(+) = 'BANK_AND_BRANCH'
And     BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
And     BRRel.STATUS(+) = 'A'
And     BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
And     BRRel.SUBJECT_TYPE(+) =  'ORGANIZATION'
And     BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
And     BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
and BankParty.PARTY_ID     =  Xi_BANK_ID
and BranchParty.party_name =  Xi_BRANCH_NAME
and BranchParty.country    =  Xi_COUNTRY_NAME
and BranchParty.PARTY_ID  <>  nvl(Xi_BRANCH_ID, -1);

Line: 751


   select count(*) into temp_number
From    HZ_PARTIES              BankParty,
        HZ_PARTIES              BranchParty,
        HZ_ORGANIZATION_PROFILES        BankOrgProfile,
        HZ_ORGANIZATION_PROFILES        BranchOrgProfile,
        HZ_RELATIONSHIPS            BRRel,
        HZ_CODE_ASSIGNMENTS         BankCA,
        HZ_CODE_ASSIGNMENTS         BranchCA
Where   BankParty.PARTY_TYPE = 'ORGANIZATION'
And     BankParty.status = 'A'
And     BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
And     SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
        and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
And     BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
And     BankCA.CLASS_CODE = 'BANK'
And     BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
And     BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
And     NVL(BankCA.STATUS, 'A') = 'A'
And     BranchParty.PARTY_TYPE(+) = 'ORGANIZATION'
And     BranchParty.status(+) = 'A'
And     BranchOrgProfile.PARTY_ID(+) = BranchParty.PARTY_ID
And     SYSDATE between TRUNC(BranchOrgProfile.effective_start_date(+))
        and NVL(TRUNC(BranchOrgProfile.effective_end_date(+)), SYSDATE+1)
And     BranchCA.CLASS_CATEGORY(+) = 'BANK_INSTITUTION_TYPE'
And     BranchCA.CLASS_CODE(+) = 'BANK_BRANCH'
And     BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
And     BranchCA.OWNER_TABLE_ID(+) = BranchParty.PARTY_ID
And     NVL(BranchCA.STATUS(+), 'A') = 'A'
And     BRRel.OBJECT_ID(+) = BankParty.PARTY_ID
And     BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID
And     BRRel.RELATIONSHIP_TYPE(+) = 'BANK_AND_BRANCH'
And     BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
And     BRRel.STATUS(+) = 'A'
And     BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
And     BRRel.SUBJECT_TYPE(+) =  'ORGANIZATION'
And     BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
And     BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
and BankParty.PARTY_ID     =  Xi_BANK_ID
and BranchOrgProfile.BANK_OR_BRANCH_NUMBER  = Xi_BRANCH_NUMBER
and BranchParty.country    =  Xi_COUNTRY_NAME
and BranchParty.PARTY_ID  <>  nvl(Xi_BRANCH_ID, -1);

Line: 836


   select count(*) into temp_name_alt
From    HZ_PARTIES              BankParty,
        HZ_PARTIES              BranchParty,
        HZ_ORGANIZATION_PROFILES        BankOrgProfile,
        HZ_ORGANIZATION_PROFILES        BranchOrgProfile,
        HZ_RELATIONSHIPS            BRRel,
        HZ_CODE_ASSIGNMENTS         BankCA,
        HZ_CODE_ASSIGNMENTS         BranchCA
Where   BankParty.PARTY_TYPE = 'ORGANIZATION'
And     BankParty.status = 'A'
And     BankParty.PARTY_ID = BankOrgProfile.PARTY_ID
And     SYSDATE between TRUNC(BankOrgProfile.effective_start_date)
        and NVL(TRUNC(BankOrgProfile.effective_end_date), SYSDATE+1)
And     BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
And     BankCA.CLASS_CODE = 'BANK'
And     BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
And     BankCA.OWNER_TABLE_ID = BankParty.PARTY_ID
And     NVL(BankCA.STATUS, 'A') = 'A'
And     BranchParty.PARTY_TYPE(+) = 'ORGANIZATION'
And     BranchParty.status(+) = 'A'
And     BranchOrgProfile.PARTY_ID(+) = BranchParty.PARTY_ID
And     SYSDATE between TRUNC(BranchOrgProfile.effective_start_date(+))
        and NVL(TRUNC(BranchOrgProfile.effective_end_date(+)), SYSDATE+1)
And     BranchCA.CLASS_CATEGORY(+) = 'BANK_INSTITUTION_TYPE'
And     BranchCA.CLASS_CODE(+) = 'BANK_BRANCH'
And     BranchCA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
And     BranchCA.OWNER_TABLE_ID(+) = BranchParty.PARTY_ID
And     NVL(BranchCA.STATUS(+), 'A') = 'A'
And     BRRel.OBJECT_ID(+) = BankParty.PARTY_ID
And     BranchParty.PARTY_ID(+) = BRRel.SUBJECT_ID
And     BRRel.RELATIONSHIP_TYPE(+) = 'BANK_AND_BRANCH'
And     BRRel.RELATIONSHIP_CODE(+) = 'BRANCH_OF'
And     BRRel.STATUS(+) = 'A'
And     BRRel.SUBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
And     BRRel.SUBJECT_TYPE(+) =  'ORGANIZATION'
And     BRRel.OBJECT_TABLE_NAME(+) = 'HZ_PARTIES'
And     BRRel.OBJECT_TYPE(+) = 'ORGANIZATION'
and BankParty.PARTY_ID     =  Xi_BANK_ID
and BranchParty.ORGANIZATION_NAME_PHONETIC =  Xi_BRANCH_NAME_ALT
and BranchParty.country    =  Xi_COUNTRY_NAME
and BranchParty.PARTY_ID  <>  nvl(Xi_BRANCH_ID, -1);

Line: 927


   select count(*) into temp_name
   from   ce_bank_accounts ba
   where ba.bank_account_name  = Xi_ACCOUNT_NAME
    and ba.bank_branch_id      = Xi_BRANCH_ID
    and ba.bank_account_id    <> nvl(Xi_ACCOUNT_ID,-1);

Line: 934


   select count(*) into temp_name
   from   ce_bank_accounts ba
   where ba.bank_account_name  = Xi_ACCOUNT_NAME
    and ba.bank_branch_id      = Xi_BRANCH_ID
    and ba.bank_account_id    <> Xi_ACCOUNT_ID;

Line: 940


   select count(*) into temp_name
   from   ce_bank_accounts ba
   where ba.bank_account_name = Xi_ACCOUNT_NAME
    and ba.bank_branch_id     = Xi_BRANCH_ID;

Line: 1440


|    Usage:        Called in update flow due to the Upgrade changes     |
|    Calls:        CE_VALIDATE_UNIQUE_BRANCH_*                         |
 --------------------------------------------------------------------- */
PROCEDURE UPD_BRANCH_UNIQUE
                            (X_COUNTRY_NAME     IN  varchar2,
                             X_BANK_NUMBER      IN  varchar2,
                             X_BRANCH_NUMBER    IN  varchar2,
                             X_BANK_NAME        IN  varchar2,
                             X_BRANCH_NAME      IN  varchar2,
                             X_BRANCH_NAME_ALT  IN  varchar2,
                             X_BANK_ID          IN  NUMBER,
                             X_BRANCH_ID        IN  NUMBER,
                             p_init_msg_list    IN  VARCHAR2,
                             x_msg_count      OUT NOCOPY NUMBER,
                             x_msg_data       OUT NOCOPY VARCHAR2,
                             X_VALUE_OUT      OUT NOCOPY varchar2,
                            x_return_status     IN OUT NOCOPY VARCHAR2,
                          X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL) AS

COUNTRY_NAME   VARCHAR2(2);

Line: 1577


|    Usage:        Called in update flow due to the Upgrade changes     |
|                  errors found in this API are treated as warnings     |
|    Calls:        CE_VALIDATE_BRANCH_*                         |
 --------------------------------------------------------------------- */
PROCEDURE UPD_BRANCH_VALIDATE
                            (X_COUNTRY_NAME     IN  varchar2,
                             X_BANK_NUMBER      IN  varchar2,
                             X_BRANCH_NUMBER    IN  varchar2,
                             X_BANK_NAME        IN  varchar2,
                             X_BRANCH_NAME      IN  varchar2,
                             X_BRANCH_NAME_ALT  IN  varchar2,
                             X_BANK_ID          IN  NUMBER,
                             X_BRANCH_ID        IN  NUMBER,
                             p_init_msg_list    IN  VARCHAR2,
                             x_msg_count      OUT NOCOPY NUMBER,
                             x_msg_data       OUT NOCOPY VARCHAR2,
                             X_VALUE_OUT      OUT NOCOPY varchar2,
                            x_return_status     IN OUT NOCOPY VARCHAR2,
                          X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL) AS

COUNTRY_NAME   VARCHAR2(2);

Line: 1852


  select
    lpad(decode(
        decode (
          substr(X_ACCOUNT_NUMBER,1,1),'7', substr(X_ACCOUNT_NUMBER,1,2),
          substr(X_ACCOUNT_NUMBER,1,1)),
        '4',    substr(X_ACCOUNT_NUMBER,1,6)||substr(X_ACCOUNT_NUMBER,8,1)||
            lpad(substr(X_ACCOUNT_NUMBER,9),7,'0'),
        '5',     substr(X_ACCOUNT_NUMBER,1,6)||substr(X_ACCOUNT_NUMBER,8,1)||
            lpad(substr(X_ACCOUNT_NUMBER,9),7,'0'),
        '71',    substr(X_ACCOUNT_NUMBER,1,6)||substr(X_ACCOUNT_NUMBER,8,1)||
            lpad(substr(X_ACCOUNT_NUMBER,9),7,'0'),
        substr(X_ACCOUNT_NUMBER,1,6)||lpad(substr(X_ACCOUNT_NUMBER,8),8,'0')
    ),14,' ')
    into account_value
    from dual;

Line: 1888


  select rpad(
              decode(
                   upper(substr(X_ACCOUNT_NUMBER, 1, 1)),
                   'P', rpad(upper(X_ACCOUNT_NUMBER), 10, ' '),
                   'G', rpad('P' || substr(X_ACCOUNT_NUMBER, 2), 10, ' '),
               'I', rpad('P' || substr(X_ACCOUNT_NUMBER, 2), 10, ' '),
                   NULL, lpad(' ', 10, ' '),
                   lpad(X_ACCOUNT_NUMBER, 10, '0')
                   )
                   ,35,' ')
    into account_value
    from dual;

Line: 2409


|    Usage:        Called in update flow due to the Upgrade changes     |
|    Calls:        CE_VALIDATE_UNIQUE_ACCOUNT_*                         |
 --------------------------------------------------------------------- */
PROCEDURE UPD_ACCOUNT_UNIQUE
                             (X_COUNTRY_NAME    IN varchar2,
                              X_BANK_NUMBER     IN varchar2,
                              X_BRANCH_NUMBER   IN varchar2,
                              X_ACCOUNT_NUMBER  IN varchar2,
                              X_BANK_ID         IN number,
                              X_BRANCH_ID       IN number,
                              X_ACCOUNT_ID      IN number,
                              X_CURRENCY_CODE   IN varchar2,
                              X_ACCOUNT_TYPE    IN varchar2,
                              X_ACCOUNT_SUFFIX  IN varchar2,
                              X_SECONDARY_ACCOUNT_REFERENCE  IN varchar2,
                              X_ACCOUNT_NAME    IN varchar2,
                              p_init_msg_list   IN  VARCHAR2,
                              x_msg_count      OUT NOCOPY NUMBER,
                              x_msg_data       OUT NOCOPY VARCHAR2,
                              X_VALUE_OUT      OUT NOCOPY varchar2,
                            x_return_status     IN OUT NOCOPY VARCHAR2,
                            X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL) AS

COUNTRY_NAME   VARCHAR2(2);

Line: 2535


|    Usage:        Called in update flow due to the Upgrade changes     |
|                  errors found in this API are treated as warnings     |
|    Calls:        CE_VALIDATE_ACCOUNT_*                                |
 --------------------------------------------------------------------- */
PROCEDURE UPD_ACCOUNT_VALIDATE
                             (X_COUNTRY_NAME    IN varchar2,
                              X_BANK_NUMBER     IN varchar2,
                              X_BRANCH_NUMBER   IN varchar2,
                              X_ACCOUNT_NUMBER  IN varchar2,
                              X_BANK_ID         IN number,
                              X_BRANCH_ID       IN number,
                              X_ACCOUNT_ID      IN number,
                              X_CURRENCY_CODE   IN varchar2,
                              X_ACCOUNT_TYPE    IN varchar2,
                              X_ACCOUNT_SUFFIX  IN varchar2,
                              X_SECONDARY_ACCOUNT_REFERENCE  IN varchar2,
                              X_ACCOUNT_NAME    IN varchar2,
                              p_init_msg_list   IN  VARCHAR2,
                              x_msg_count      OUT NOCOPY NUMBER,
                              x_msg_data       OUT NOCOPY VARCHAR2,
                              X_VALUE_OUT      OUT NOCOPY varchar2,
                            x_return_status     IN OUT NOCOPY VARCHAR2,
                            X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL,
                X_CD                 IN  varchar2  DEFAULT NULL,
                    X_ELECTRONIC_ACCT_NUM    OUT NOCOPY varchar2) AS

COUNTRY_NAME   VARCHAR2(2);

Line: 3034


|    Usage:        Called in update flow due to the Upgrade changes     |
|    Calls:        CE_VALIDATE_UNIQUE_BANK_*                         |
 --------------------------------------------------------------------- */
PROCEDURE UPD_BANK_UNIQUE
                          ( X_COUNTRY_NAME    IN varchar2,
                            X_BANK_NUMBER     IN varchar2,
                            X_BANK_NAME       IN varchar2,
                            X_BANK_NAME_ALT   IN varchar2,
                            X_TAX_PAYER_ID    IN varchar2,
                            X_BANK_ID         IN NUMBER,
                            p_init_msg_list   IN VARCHAR2,
                            x_msg_count      OUT NOCOPY NUMBER,
                            x_msg_data       OUT NOCOPY VARCHAR2,
                            X_VALUE_OUT      OUT NOCOPY varchar2,
                            x_return_status     IN OUT NOCOPY VARCHAR2,
                          X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL) AS

COUNTRY_NAME   VARCHAR2(2);

Line: 3140


|    Usage:        Called in update flow due to the Upgrade changes     |
|                  errors found in this API are treated as warnings     |
|    Calls:        CE_VALIDATE_BANK_*                                   |
 --------------------------------------------------------------------- */
PROCEDURE UPD_BANK_VALIDATE
                          ( X_COUNTRY_NAME    IN varchar2,
                            X_BANK_NUMBER     IN varchar2,
                            X_BANK_NAME       IN varchar2,
                            X_BANK_NAME_ALT   IN varchar2,
                            X_TAX_PAYER_ID    IN varchar2,
                            X_BANK_ID         IN NUMBER,
                            p_init_msg_list   IN VARCHAR2,
                            x_msg_count      OUT NOCOPY NUMBER,
                            x_msg_data       OUT NOCOPY VARCHAR2,
                            X_VALUE_OUT      OUT NOCOPY varchar2,
                            x_return_status     IN OUT NOCOPY VARCHAR2,
                          X_ACCOUNT_CLASSIFICATION IN VARCHAR2 DEFAULT NULL) AS

COUNTRY_NAME   VARCHAR2(2);

Line: 3408


            SELECT meaning
            INTO length_val
            FROM fnd_lookup_values_vl
            WHERE lookup_type = 'NUMBERS'
            AND lookup_code = p_Token;

Line: 5577


	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;

Line: 7276


   select count(*) into temp_number
   from ce_bank_accounts ba
   where ba.bank_account_num = Xi_ACCOUNT_NUMBER
    and ba.bank_account_name = Xi_ACCOUNT_NAME
    and ba.bank_branch_id    = Xi_BRANCH_ID
    and ba.currency_code     = Xi_CURRENCY_CODE
    and ba.bank_account_id  <> nvl(Xi_ACCOUNT_ID,-1);

Line: 7285


   select count(*) into temp_number
   from ce_bank_accounts ba
   where ba.bank_account_num = Xi_ACCOUNT_NUMBER
    and ba.bank_branch_id    = Xi_BRANCH_ID
    and ba.currency_code     = Xi_CURRENCY_CODE
    and ba.bank_account_id   <> Xi_ACCOUNT_ID;

Line: 7292


   select count(*) into temp_number
   from ce_bank_accounts ba
   where ba.bank_account_num = Xi_ACCOUNT_NUMBER
    and ba.bank_branch_id    = Xi_BRANCH_ID
    and ba.currency_code     = Xi_CURRENCY_CODE;

Line: 7341


   select count(*) into temp_number
   from ce_bank_accounts ba
   where ba.bank_account_num = Xi_ACCOUNT_NUMBER
    and ba.bank_account_name = Xi_ACCOUNT_NAME
    and ba.bank_account_type = Xi_ACCOUNT_TYPE
    and ba.currency_code     = Xi_CURRENCY_CODE
    and ba.bank_branch_id    = Xi_BRANCH_ID
    and ba.bank_account_id  <> nvl(Xi_ACCOUNT_ID,-1);

Line: 7351


   select count(*) into temp_number
   from ce_bank_accounts ba
   where ba.bank_account_num = Xi_ACCOUNT_NUMBER
    and ba.bank_account_type = Xi_ACCOUNT_TYPE
    and ba.currency_code     = Xi_CURRENCY_CODE
    and ba.bank_branch_id    = Xi_BRANCH_ID
    and ba.bank_account_id  <> Xi_ACCOUNT_ID;

Line: 7359


   select count(*) into temp_number
   from ce_bank_accounts ba
   where ba.bank_account_num = Xi_ACCOUNT_NUMBER
    and ba.bank_account_type = Xi_ACCOUNT_TYPE
    and ba.currency_code     = Xi_CURRENCY_CODE
    and ba.bank_branch_id    = Xi_BRANCH_ID;

Line: 7409


   select count(*) into temp_number
   from ce_bank_accounts ba
   where ba.bank_account_num = Xi_ACCOUNT_NUMBER
    and ba.bank_account_name = Xi_ACCOUNT_NAME
    and ba.account_suffix    = Xi_ACCOUNT_SUFFIX
    and ba.currency_code     = Xi_CURRENCY_CODE
    and ba.bank_branch_id    = Xi_BRANCH_ID
    and ba.bank_account_id  <> nvl(Xi_ACCOUNT_ID,-1);

Line: 7579


   select count(*) into temp_name_alt
    From  HZ_PARTIES   HzPartyBankEO,
    HZ_ORGANIZATION_PROFILES   HzOrgProfileBankEO,
    HZ_CODE_ASSIGNMENTS   HzCodeAssignmentBankEO
   Where
      HzPartyBankEO.ORGANIZATION_NAME_PHONETIC =  Xi_BANK_NAME_ALT
    and   HzPartyBankEO.country     = Xi_COUNTRY_NAME
     and  HzPartyBankEO.PARTY_TYPE = 'ORGANIZATION'
     and  HzPartyBankEO.status = 'A'
     And  HzPartyBankEO.PARTY_ID = HzOrgProfileBankEO.PARTY_ID
     and   sysdate between trunc(HzOrgProfileBankEO.EFFECTIVE_START_DATE)
                and nvl(trunc(HzOrgProfileBankEO.EFFECTIVE_END_DATE),sysdate)
     And     HzCodeAssignmentBankEO.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
     And     HzCodeAssignmentBankEO.CLASS_CODE = 'BANK'
     And     HzCodeAssignmentBankEO.OWNER_TABLE_NAME = 'HZ_PARTIES'
     And     HzCodeAssignmentBankEO.OWNER_TABLE_ID = HzPartyBankEO.PARTY_ID
     And    nvl(HzCodeAssignmentBankEO.status, 'A') = 'A'
     And  HzPartyBankEO.PARTY_ID = nvl(Xi_BANK_ID, -1);