[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select distinct s.script_name, s.script_type, s.package_name
from XTR_DEAL_DATE_AMOUNTS_V dda,
XTR_BANK_ACCOUNTS ba,
XTR_SETTLEMENT_SCRIPTS s
WHERE trunc(dda.actual_settlement_date) = trunc(NVL(Settlement_date,dda.actual_settlement_date))
and dda.company_code = NVL(l_company, dda.company_code)
and NVL(dda.beneficiary_party,dda.cparty_code) like NVL(l_cparty,'%')
and dda.amount >= NVL(l_setl_amt_from, dda.amount)
and dda.amount <= NVL(l_setl_amt_to, dda.amount)
and dda.account_no = NVL(l_account, dda.account_no)
and dda.currency = NVL(l_currency, dda.currency)
and dda.trans_mts = 'Y'
and ((upper(l_prev_run) = 'Y') or (upper(l_prev_run) = 'N'
and dda.settlement_actioned is NULL))
and ba.account_number = dda.account_no
and ba.party_code = NVL(l_company, ba.party_code)
and ba.eft_script_name = NVL(l_script_name, ba.eft_script_name)
and s.company_code = dda.company_code
and s.script_name = ba.eft_script_name
and nvl(s.currency_code,ba.currency) = ba.currency;