[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select BAU.CUSTOMER_ID, BAU.CUSTOMER_SITE_USE_ID,
BAU.PRIMARY_FLAG, BAU.START_DATE,
BAU.END_DATE, BAC.BANK_ACCOUNT_NUM,
BAC.BANK_ACCOUNT_NAME, BAC.CURRENCY_CODE,
BAC.DESCRIPTION, BAC.MAX_CHECK_AMOUNT,
BAC.MIN_CHECK_AMOUNT, BAC.INACTIVE_DATE,
BAC.ASSET_CODE_COMBINATION_ID,
BAC.GAIN_CODE_COMBINATION_ID,
BAC.LOSS_CODE_COMBINATION_ID,
BAC.BANK_ACCOUNT_TYPE, BAC.MAX_OUTLAY,
BAC.MULTI_CURRENCY_FLAG, BAC.ACCOUNT_TYPE,
BAC.POOLED_FLAG, BAC.ZERO_AMOUNTS_ALLOWED,
BAU.ATTRIBUTE_CATEGORY, BAU.ATTRIBUTE1,
BAU.ATTRIBUTE2, BAU.ATTRIBUTE3,
BAU.ATTRIBUTE4, BAU.ATTRIBUTE5,
BAU.ATTRIBUTE6, BAU.ATTRIBUTE7,
BAU.ATTRIBUTE8, BAU.ATTRIBUTE9,
BAU.ATTRIBUTE10, BAU.ATTRIBUTE11,
BAU.ATTRIBUTE12, BAU.ATTRIBUTE13,
BAU.ATTRIBUTE14, BAU.ATTRIBUTE15,
BAU.CREATED_BY, BAU.CREATION_DATE,
BAU.LAST_UPDATE_DATE, BAU.LAST_UPDATED_BY
from AP_BANK_ACCOUNT_USES_ALL BAU,
AP_BANK_ACCOUNTS_ALL BAC
where ((BAU.customer_id = nvl(cust_id, BAU.customer_id)
and BAU.customer_site_use_id =
nvl(siteuseid, BAU.customer_site_use_id))
or (BAU.customer_id = nvl(cust_id, BAU.customer_id)
and BAU.customer_site_use_id is null))
and BAU.external_bank_account_id = BAC.bank_account_id
and BAU.last_update_date between
nvl(start_date, BAU.last_update_date)
and nvl(end_date, BAU.last_update_date)
order by BAU.customer_id, BAU.customer_site_use_id,
BAU.primary_flag desc;
last_update_date out date,
last_updated_by out varchar2,
row_to_fetch in out number,
error_status out number) is
createdby number;
last_update_date, modifiedby;
last_updated_by := gmf_fnd_get_users.fnd_get_users(modifiedby);