APPS.CE_BANK_AND_ACCOUNT_UTIL SQL Statements

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

Line: 26

     SELECT bank_account_num
     INTO   l_bank_acct_num
     FROM   ce_bank_accounts
     WHERE  bank_account_id = p_bank_acct_id;

Line: 79

     SELECT  IBAN_NUMBER
     INTO   l_IBAN
     FROM   ce_bank_accounts
     WHERE  bank_account_id = p_bank_acct_id;

Line: 132

     /* select bank_account_id's  */
     SELECT DISTINCT bank_account_id
     BULK COLLECT
     INTO bank_acct_idtbl
     FROM ce_bank_acct_uses_all
     WHERE org_id = p_org_id;

Line: 217

     /* select bank_account_id's  */
     IF p_org_type = 'LEGAL_ENTITY' THEN
       SELECT BA.bank_account_id
       BULK COLLECT
       INTO x_bank_acct_ids
       FROM (	SELECT 	ce_ba.bank_account_id
		FROM 	ce_bank_accounts      ce_ba,
            		ce_bank_acct_uses_all ce_bau
       		WHERE 	ce_ba.bank_account_id = ce_bau.bank_account_id
       		AND   	NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
		AND   	(ce_ba.currency_code = p_currency
			or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
       		AND   	ce_bau.legal_entity_id = p_org_id
		UNION
		SELECT	bank_account_id
		FROM 	ce_bank_accounts
		WHERE 	NVL(end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
		AND   	(currency_code = p_currency
			or MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
       		AND   	account_owner_org_id = p_org_id) BA;

Line: 238

       SELECT ce_ba.bank_account_id
       BULK COLLECT
       INTO x_bank_acct_ids
       FROM ce_bank_accounts      ce_ba,
  	    ce_bank_acct_uses_all ce_bau
       WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
       AND   NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
       AND   (ce_ba.currency_code = p_currency
		or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
       AND   ce_bau.org_id = p_org_id;

Line: 288

     /* select bank_account_id's  */
     IF (p_internal_bank_account_id IS NOT NULL) THEN
          IF p_org_type = 'LEGAL_ENTITY' THEN
            SELECT Count(BA.bank_account_id)
            INTO   l_count
            FROM (	SELECT 	ce_ba.bank_account_id
	                  FROM 	ce_bank_accounts      ce_ba,
            	      ce_bank_acct_uses_all ce_bau
       	            WHERE 	ce_ba.bank_account_id = ce_bau.bank_account_id
                    AND     ce_ba.bank_account_id = p_internal_bank_account_id
       	            AND   	NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
	                  AND   	(ce_ba.currency_code = p_currency
		                 or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
       	            AND   	ce_bau.legal_entity_id = p_org_id
	                  UNION
	                  SELECT	bank_account_id
	                  FROM 	  ce_bank_accounts
	                  WHERE  bank_account_id = p_internal_bank_account_id
                    AND    NVL(end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
	                  AND   	(currency_code = p_currency
		                  or MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
       	            AND   	account_owner_org_id = p_org_id
                  )BA;

Line: 313

            SELECT Count(ce_ba.bank_account_id)
            INTO l_count
            FROM ce_bank_accounts      ce_ba,
  	        ce_bank_acct_uses_all ce_bau
            WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
            AND   ce_ba.bank_account_id = p_internal_bank_account_id
            AND   NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
            AND   (ce_ba.currency_code = p_currency
	                 or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
            AND   ce_bau.org_id = p_org_id;

Line: 334

            SELECT BA.bank_account_id
            BULK COLLECT
            INTO l_bank_acct_ids
            FROM (	SELECT 	ce_ba.bank_account_id
	           FROM 	ce_bank_accounts      ce_ba,
            	      ce_bank_acct_uses_all ce_bau
       	      WHERE 	ce_ba.bank_account_id = ce_bau.bank_account_id
       	      AND   	NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
	          AND   	(ce_ba.currency_code = p_currency
		          or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
       	          AND   	ce_bau.legal_entity_id = p_org_id
	          UNION
	          SELECT	bank_account_id
	          FROM 	ce_bank_accounts
	          WHERE 	NVL(end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
	          AND   	(currency_code = p_currency
		          or MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
       	        AND   	account_owner_org_id = p_org_id) BA;

Line: 354

            SELECT ce_ba.bank_account_id
            BULK COLLECT
            INTO l_bank_acct_ids
            FROM ce_bank_accounts      ce_ba,
  	        ce_bank_acct_uses_all ce_bau
            WHERE ce_ba.bank_account_id = ce_bau.bank_account_id
            AND   NVL(ce_ba.end_date, NVL(p_date, sysdate)) >= NVL(p_date, sysdate)
            AND   (ce_ba.currency_code = p_currency
	          or ce_ba.MULTI_CURRENCY_ALLOWED_FLAG = 'Y') --bug 4915527
            AND   ce_bau.org_id = p_org_id;