APPS.IBY_EXT_BANKACCT_VALIDATIONS SQL Statements

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

Line: 1799

      SELECT hz_p.party_name, hz_org.bank_or_branch_number, hz_org.home_country
      FROM   hz_parties                 hz_p,
             hz_organization_profiles   hz_org
      WHERE  hz_p.party_id = hz_org.party_id
      AND    SYSDATE between TRUNC(hz_org.effective_start_date)
             and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)
      AND    hz_p.party_id = p_ext_bank_acct_rec.bank_id;

Line: 1815

     SELECT count(1)
     FROM IBY_EXT_BANK_ACCOUNTS
     WHERE ((BANK_ACCOUNT_NUM = p_account_number) OR
             (BANK_ACCOUNT_NUM_HASH1=  iby_security_pkg.Get_Hash
                       (p_account_number,'F')
                       AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash
                       (p_account_number,'T') ))
         AND ((p_currency IS NULL and CURRENCY_CODE is NULL)  OR (CURRENCY_CODE = p_currency))
        AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))
        AND ((p_branch_id IS NULL AND BRANCH_ID is NULL) OR (BRANCH_ID = p_branch_id))
       AND p_country_code=COUNTRY_CODE
     AND ((p_bank_account_id is NULL) OR p_bank_account_id<>EXT_BANK_ACCOUNT_ID);

Line: 1839

     SELECT count(1)
     FROM IBY_EXT_BANK_ACCOUNTS
     WHERE ((BANK_ACCOUNT_NUM = p_account_number) OR
             (BANK_ACCOUNT_NUM_HASH1=  iby_security_pkg.Get_Hash
                       (p_account_number,'F')
                       AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash
                       (p_account_number,'T') ))
       AND ((p_currency IS NULL and CURRENCY_CODE is NULL)  OR (CURRENCY_CODE = p_currency))
        AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))
        AND ((p_branch_id IS NULL AND BRANCH_ID is NULL) OR (BRANCH_ID = p_branch_id))
       AND p_country_code=COUNTRY_CODE
       AND ((p_acct_id IS NULL) OR (EXT_BANK_ACCOUNT_ID <> p_acct_id))
       AND ((p_acct_type is NULL and BANK_ACCOUNT_TYPE is NULL)OR (p_acct_type=BANK_ACCOUNT_TYPE));

Line: 1863

     SELECT count(1)
     FROM IBY_EXT_BANK_ACCOUNTS
     WHERE ((BANK_ACCOUNT_NUM = p_account_number) OR
             (BANK_ACCOUNT_NUM_HASH1=  iby_security_pkg.Get_Hash
                       (p_account_number,'F')
                       AND BANK_ACCOUNT_NUM_HASH2=iby_security_pkg.Get_Hash
                       (p_account_number,'T') ))
       AND ((p_currency IS NULL and CURRENCY_CODE is NULL)  OR (CURRENCY_CODE = p_currency))
        AND ((p_bank_id IS NULL AND BANK_ID is NULL) OR (BANK_ID = p_bank_id))
        AND ((p_branch_id IS NULL AND BRANCH_ID is NULL) OR (BRANCH_ID = p_branch_id))
       AND p_country_code=COUNTRY_CODE
       AND ((p_acct_id IS NULL) OR (EXT_BANK_ACCOUNT_ID <> p_acct_id))
       AND ((p_acct_suffix is NULL and ACCOUNT_SUFFIX is NULL)OR (p_acct_suffix=ACCOUNT_SUFFIX));

Line: 1911

         SELECT COUNT(EXT_BANK_ACCOUNT_ID)
           INTO l_count
           FROM IBY_EXT_BANK_ACCOUNTS_V
          WHERE BANK_ACCOUNT_NAME =p_ext_bank_acct_rec.bank_account_name;

Line: 2500

      SELECT CURRENCY_CODE
        FROM FND_CURRENCIES
       WHERE CURRENCY_CODE = p_currency_code;