The following lines contain the word 'select', 'insert', 'update' or 'delete':
select BAU.CUSTOMER_ID,
BAU.CUSTOMER_SITE_USE_ID,
BAC.CURRENCY_CODE
from AP_BANK_ACCOUNT_USES_ALL BAU,
AP_BANK_ACCOUNTS_ALL BAC
where ((BAU.customer_id = nvl(custid, BAU.customer_id)
and BAU.customer_site_use_id =
nvl(siteuseid, BAU.customer_site_use_id))
or (BAU.customer_id = nvl(custid, BAU.customer_id)
and BAU.customer_site_use_id is null))
and upper(BAU.primary_flag) like 'Y%'
and BAU.external_bank_account_id = BAC.bank_account_id
and nvl(bau.org_id,0) = nvl(orgid, nvl(bau.org_id,0))
order by BAU.customer_id, BAU.customer_site_use_id;
select count(*)
into no_of_site_accounts
from AP_BANK_ACCOUNT_USES_ALL BAU
where BAU.customer_id = nvl(cust_id, BAU.customer_id)
and BAU.customer_site_use_id =
nvl(site_use_id, BAU.customer_site_use_id)
and upper(bau.primary_flag) like 'Y%';
select count(*)
into no_of_cust_accounts
from AP_BANK_ACCOUNT_USES_ALL BAU
where BAU.customer_id = nvl(cust_id, BAU.customer_id)
and BAU.customer_site_use_id IS NULL
and upper(bau.primary_flag) like 'Y%'
and nvl(bau.org_id,0) = nvl(porg_id, nvl(bau.org_id,0));