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

     /* 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: 159

     /* 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: 180

       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;