APPS.GMF_AR_GET_CUST_CURRENCY SQL Statements

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

Line: 6

             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;

Line: 41

             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%';

Line: 54

		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));