[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT PARENT_OBJECT_ID,PARENT_OBJECT_CODE,EXPECTED_START_DATE,TERM
FROM OKL_LEASE_QUOTES_V
where id=p_lease_quote_id;
select lop.id,
lop.reference_number,
lop.prospect_id,
lop.prospect_address_id,
lop.cust_acct_id,
OKL_LEASE_APP_PVT.get_credit_classfication(
lop.prospect_id,
lop.cust_acct_id,
NULL) as customer_credit_class,
lop.sales_rep_id,
lop.sales_territory_id,
lop.currency_code
from okl_lease_opportunities_v lop
where lop.id=p_parent_object_id;
select lapp.id,
lapp.reference_number,
lapp.prospect_id,
lapp.prospect_address_id,
lapp.cust_acct_id,
OKL_LEASE_APP_PVT.get_credit_classfication(
lapp.prospect_id,
lapp.cust_acct_id,
NULL) as customer_credit_class,
lapp.sales_rep_id,
lapp.sales_territory_id,
lapp.currency_code
from okl_lease_applications_v lapp
where lapp.id=p_parent_object_id;
select SUM(OEC)
FROM OKL_LEASE_QUOTES_B OLQ,OKL_ASSETS_B OAB
where OAB.PARENT_OBJECT_ID = OLQ.ID
AND OAB.PARENT_OBJECT_CODE='LEASEQUOTE'
AND OLQ.ID= p_parent_object_id;
SELECT SUM(NVL(VALUE,0))
FROM OKL_COST_ADJUSTMENTS_B OCA,
OKL_ASSETS_B OAB
where OAB.PARENT_OBJECT_CODE = 'LEASEQUOTE'
AND OCA.PARENT_OBJECT_CODE='ASSET'
AND OCA.PARENT_OBJECT_ID=OAB.ID
and ADJUSTMENT_SOURCE_TYPE =p_adj_type
AND OAB.PARENT_OBJECT_ID = p_quote_id;
select OAC.INV_ITEM_ID
from OKL_ASSET_COMPONENTS_B OAC,
OKL_ASSETS_B OAB
WHERE OAC.ASSET_ID = OAB.ID
AND OAB.PARENT_OBJECT_CODE = 'LEASEQUOTE'
AND PRIMARY_COMPONENT='YES'
AND OAB.PARENT_OBJECT_ID = p_quote_id;
SELECT PARENT_OBJECT_ID,PARENT_OBJECT_CODE
FROM OKL_LEASE_QUOTES_b
where id=p_lease_quote_id;
select PROGRAM_AGREEMENT_ID
from okl_lease_opportunities_b
where id=p_object_id;
select PROGRAM_AGREEMENT_ID
from okl_lease_applications_b
where id=p_object_id;
select lrs.id,
lrv.rate_set_version_id,
lrv.version_number,
lrs.name,
lrs.description,
lrv.effective_from_date effective_from,
lrv.effective_to_date effective_to,
--Bug # 5050143 start
nvl(lrv.lrs_rate,lrv.standard_rate) lrs_rate,
--Bug # 5050143 End
lrv.sts_code,
lrs.frq_code
from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv
where effective_start_date between lrv.effective_from_date and NVL(lrv.effective_to_date,effective_start_date+1)
and lrs.id=lrv.rate_set_id
and lrv.sts_code='ACTIVE'
and lrs.lrs_type_code='LEVEL'
AND lrs.currency_code = p_currency_code;
--Modified SRT selection To include Valid Index Rate Type SRT
--Bug # 5045505 ssdeshpa start
--Modified To inlude more Attribute Selection
--Issue # 9 Modified to Filter SRT on the Basis of Currency Code Passed
CURSOR c_srt_rec(effective_start_date DATE,
p_currency_code VARCHAR2) IS
select srt.std_rate_tmpl_id as id,
srv.std_rate_tmpl_ver_id,
srv.version_number,
srt.template_name as name,
srt.template_desc as description,
srt.frequency_code as frq_code,
srv.effective_from_date effective_from,
srv.effective_to_date effective_to,
srv.srt_rate,
srv.sts_code,
srv.day_convention_code,
----------
srt.pricing_engine_code pricing_engine_code,
srt.rate_type_code rate_type_code,
srt.index_id index_id,
srv.spread spread,
srt.frequency_code frequency_code,
srv.adj_mat_version_id adj_mat_version_id,
srv.max_adj_rate,
srv.min_adj_rate
---
from
okl_fe_std_rt_tmp_v srt,
okl_fe_std_rt_tmp_vers srv
where
effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
AND srt.std_rate_tmpl_id=srv.std_rate_tmpl_id
AND srv.sts_code='ACTIVE'
AND srt.rate_card_yn = 'N'
AND srt.RATE_TYPE_CODE = 'BASE_RATE'
AND srt.currency_code = p_currency_code
UNION
select srt.std_rate_tmpl_id as id,
srv.std_rate_tmpl_ver_id,
srv.version_number,
srt.template_name as name,
srt.template_desc as description,
srt.frequency_code as frq_code,
srv.effective_from_date effective_from,
srv.effective_to_date effective_to,
srv.srt_rate,
srv.sts_code,
srv.day_convention_code,
----------
srt.pricing_engine_code pricing_engine_code,
srt.rate_type_code rate_type_code,
srt.index_id index_id,
srv.spread spread,
srt.frequency_code frequency_code,
srv.adj_mat_version_id adj_mat_version_id,
srv.max_adj_rate,
srv.min_adj_rate
---
from
okl_fe_std_rt_tmp_v srt,
okl_fe_std_rt_tmp_vers srv,
okl_index_values oiv
where
effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
and srt.std_rate_tmpl_id=srv.std_rate_tmpl_id
and srv.sts_code='ACTIVE'
AND srt.rate_card_yn = 'N'
AND srt.index_id = oiv.idx_id
AND effective_start_date BETWEEN oiv.datetime_valid AND nvl(oiv.datetime_invalid, effective_start_date + 1)
AND srt.RATE_TYPE_CODE = 'INDEX_RATE'
AND srt.currency_code = p_currency_code;
select lrs.id,
lrv.rate_set_version_id,
lrv.version_number,
lrs.name,
lrs.description,
lrv.effective_from_date effective_from,
lrv.effective_to_date effective_to,
--Bug # 5050143 start
nvl(lrv.lrs_rate,lrv.standard_rate) lrs_rate,
--Bug # 5050143 start
lrv.sts_code,
lrs.frq_code
from okl_ls_rt_fctr_sets_v lrs,okl_fe_rate_set_versions_v lrv
where
effective_start_date between lrv.effective_from_date and NVL(lrv.effective_to_date,effective_start_date+1)
AND lrs.id=lrv.rate_set_id
and lrv.sts_code='ACTIVE'
AND lrs.currency_code = p_currency_code;
--Modified SRT selection To include Valid Index Rate Type SRT
--Bug # 5045505 ssdeshpa start
--Modified To inlude more Attribute Selection
CURSOR c_srt_rec(effective_start_date DATE,
p_currency_code VARCHAR2) IS
select srt.std_rate_tmpl_id as id,
srv.std_rate_tmpl_ver_id,
srv.version_number,
srt.template_name as name,
srt.template_desc as description,
srt.frequency_code as frq_code,
srv.effective_from_date effective_from,
srv.effective_to_date effective_to,
srv.srt_rate,
srv.sts_code,
srv.day_convention_code,
----------
srt.pricing_engine_code pricing_engine_code,
srt.rate_type_code rate_type_code,
srt.index_id index_id,
srv.spread spread,
srt.frequency_code frequency_code,
srv.adj_mat_version_id adj_mat_version_id,
srv.max_adj_rate,
srv.min_adj_rate
---
from
okl_fe_std_rt_tmp_v srt,
okl_fe_std_rt_tmp_vers srv
where
effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
AND srt.std_rate_tmpl_id=srv.std_rate_tmpl_id
AND srv.sts_code='ACTIVE'
AND srt.rate_card_yn = 'N'
AND srt.RATE_TYPE_CODE = 'BASE_RATE'
AND srt.currency_code = p_currency_code
UNION
select srt.std_rate_tmpl_id as id,
srv.std_rate_tmpl_ver_id,
srv.version_number,
srt.template_name as name,
srt.template_desc as description,
srt.frequency_code as frq_code,
srv.effective_from_date effective_from,
srv.effective_to_date effective_to,
srv.srt_rate,
srv.sts_code,
srv.day_convention_code,
----------
srt.pricing_engine_code pricing_engine_code,
srt.rate_type_code rate_type_code,
srt.index_id index_id,
srv.spread spread,
srt.frequency_code frequency_code,
srv.adj_mat_version_id adj_mat_version_id,
srv.max_adj_rate,
srv.min_adj_rate
---
from
okl_fe_std_rt_tmp_v srt,
okl_fe_std_rt_tmp_vers srv,
okl_index_values oiv
where
effective_start_date between srv.effective_from_date and NVL(srv.effective_to_date,effective_start_date+1)
and srt.std_rate_tmpl_id=srv.std_rate_tmpl_id
and srv.sts_code='ACTIVE'
AND srt.rate_card_yn = 'N'
AND srt.index_id = oiv.idx_id
AND effective_start_date BETWEEN oiv.datetime_valid AND nvl(oiv.datetime_invalid, effective_start_date + 1)
AND srt.RATE_TYPE_CODE = 'INDEX_RATE'
AND srt.currency_code = p_currency_code;
SELECT pdt.id ID,
pdt.name NAME,
pqy.name PRODUCT_SUBCLASS,
pdt.version VERSION,
pdt.description DESCRIPTION,
pdt.PRODUCT_STATUS_CODE PRODUCT_STATUS_CODE,
qve.VALUE Deal_Type,
Okl_Accounting_Util.Get_Lookup_Meaning('OKL_SECURITIZATION_TYPE', qve.VALUE) Deal_Type_meaning
FROM OKL_PRODUCTS PDT,
OKL_PQY_VALUES qve,
OKL_PDT_QUALITYS PQY,
OKL_PDT_PQY_VALS PQV
where
pdt.id = pqv.pdt_id
and qve.pqy_id = pqy.id
AND pqv.qve_id = qve.id
AND pqy.name In ('INVESTOR','LEASE')
and effective_start_date BETWEEN pdt.from_date
and NVL(pdt.to_date,SYSDATE)
and pdt.product_status_code='APPROVED';
select prod.id,
prod.name,
prod.product_subclass,
prod.version,
prod.description,
prod.product_status_code,
prod.deal_type,
prod.deal_type_meaning
from okl_product_parameters_v prod,OKL_VP_ASSOCIATIONS vp
where
--effective_start_date BETWEEN prod.from_date and NVL(prod.to_date,SYSDATE)
--and
vp.ASSOC_OBJECT_TYPE_CODE='LA_FINANCIAL_PRODUCT'
and prod.id =vp.ASSOC_OBJECT_ID
and vp.chr_id=l_vendor_prog_id
AND prod.product_status_code='APPROVED';
select tbl.id,
tbl.contract_number,
tbl.start_date,
tbl.end_date
from okc_k_headers_v tbl
where effective_start_date between tbl.start_date and NVL(tbl.end_date,effective_start_date+1)
AND tbl.SCS_CODE='PROGRAM'
AND tbl.STS_CODE='ACTIVE'
AND tbl.template_yn='N';