The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
pdt.id pdt_id,
chr.start_date,
khr.deal_type,
nvl(pdt.reporting_pdt_id, -1) report_pdt_id
FROM okc_k_headers_v chr,
okl_k_headers khr,
okl_products_v pdt
WHERE khr.id = chr.id
AND chr.id = l_khr_id
AND khr.pdt_id = pdt.id(+);
SELECT
TLN.PRIMARY_STY_ID,
STY.NAME PRIMARY_STY_NAME
FROM
OKL_ST_GEN_TMPT_LNS TLN,
OKL_ST_GEN_TEMPLATES TMPT,
OKL_ST_GEN_TMPT_SETS Tst,
OKL_AE_TMPT_SETS AES,
OKL_PRODUCTS_V PDT,
OKL_STRM_TYPE_v STY
WHERE
TLN.GTT_ID = TMPT.ID AND
TMPT.GTS_ID = Tst.ID AND
Tst.ID = AES.GTS_ID AND
--TST.deal_type = p_deal_type AND
AES.ID = PDT.AES_ID AND
TLN.PRIMARY_STY_ID = STY.ID
AND TLN.PRIMARY_YN = 'Y'
AND PDT.ID = l_pdt_id
AND (TMPT.START_DATE <= l_contract_start_date)
AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND STY.STREAM_TYPE_PURPOSE = p_primary_sty_purpose;
SELECT
pdt.id pdt_id,
chr.start_date,
khr.deal_type,
nvl(pdt.reporting_pdt_id, -1) report_pdt_id
FROM okc_k_headers_v chr,
okl_k_headers khr,
okl_products_v pdt
WHERE khr.id = chr.id
AND chr.id = l_khr_id
AND khr.pdt_id = pdt.id(+);
SELECT
TLN.PRIMARY_STY_ID,
STY.NAME PRIMARY_STY_NAME
FROM
OKL_ST_GEN_TMPT_LNS TLN,
OKL_ST_GEN_TEMPLATES TMPT,
OKL_ST_GEN_TMPT_SETS Tst,
OKL_AE_TMPT_SETS AES,
OKL_PRODUCTS_V PDT,
OKL_STRM_TYPE_v STY
WHERE
TLN.GTT_ID = TMPT.ID AND
TMPT.GTS_ID = Tst.ID AND
Tst.ID = AES.GTS_ID AND
TST.deal_type = p_deal_type AND
AES.ID = PDT.AES_ID AND
TLN.PRIMARY_STY_ID = STY.ID
AND TLN.PRIMARY_YN = 'Y'
AND PDT.ID = l_pdt_id
AND (TMPT.START_DATE <= l_contract_start_date)
AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND STY.STREAM_TYPE_PURPOSE = p_primary_sty_purpose;
SELECT pdt_id, start_date
FROM okl_k_headers_full_v
WHERE id = l_khr_id; */
SELECT
pdt.id pdt_id,
chr.start_date,
khr.deal_type,
nvl(pdt.reporting_pdt_id, -1) report_pdt_id
FROM okc_k_headers_v chr,
okl_k_headers khr,
okl_products_v pdt
WHERE khr.id = chr.id
AND chr.id = l_khr_id
AND khr.pdt_id = pdt.id(+);
SELECT
TLN.DEPENDENT_STY_ID,
STY1.NAME DEPENDENT_STY_NAME
FROM
OKL_ST_GEN_TMPT_LNS TLN,
OKL_ST_GEN_TEMPLATES TMPT,
OKL_ST_GEN_TMPT_SETS Tst,
OKL_AE_TMPT_SETS AES,
OKL_PRODUCTS_V PDT,
OKL_STRM_TYPE_v STY
, OKL_STRM_TYPE_v STY1
WHERE
TLN.GTT_ID = TMPT.ID AND
TMPT.GTS_ID = Tst.ID AND
Tst.ID = AES.GTS_ID AND
--TST.deal_type = p_deal_type AND
AES.ID = PDT.AES_ID AND
TLN.PRIMARY_STY_ID = STY.ID
AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
AND TLN.PRIMARY_YN = 'N'
AND PDT.ID = l_pdt_id
AND (TMPT.START_DATE <= l_contract_start_date)
AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
SELECT pdt_id, start_date
FROM okl_k_headers_full_v
WHERE id = l_khr_id; */
SELECT
pdt.id pdt_id,
chr.start_date,
khr.deal_type,
nvl(pdt.reporting_pdt_id, -1) report_pdt_id
FROM okc_k_headers_v chr,
okl_k_headers khr,
okl_products_v pdt
WHERE khr.id = chr.id
AND chr.id = l_khr_id
AND khr.pdt_id = pdt.id(+);
SELECT
TLN.DEPENDENT_STY_ID,
STY1.NAME DEPENDENT_STY_NAME
FROM
OKL_ST_GEN_TMPT_LNS TLN,
OKL_ST_GEN_TEMPLATES TMPT,
OKL_ST_GEN_TMPT_SETS Tst,
OKL_AE_TMPT_SETS AES,
OKL_PRODUCTS_V PDT,
OKL_STRM_TYPE_v STY
, OKL_STRM_TYPE_v STY1
WHERE
TLN.GTT_ID = TMPT.ID AND
TMPT.GTS_ID = Tst.ID AND
Tst.ID = AES.GTS_ID AND
TST.deal_type = p_deal_type AND
AES.ID = PDT.AES_ID AND
TLN.PRIMARY_STY_ID = STY.ID
AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
AND TLN.PRIMARY_YN = 'N'
AND PDT.ID = l_pdt_id
AND (TMPT.START_DATE <= l_contract_start_date)
AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
SELECT deal_type
FROM okl_k_headers_h
WHERE id = l_khr_id;
SELECT LOOKUP_CODE FROM fnd_lookups
WHERE lookup_type = 'OKL_STREAM_TYPE_PURPOSE' AND
lookup_code = l_lookup_code;
select kle.id,
lse.lty_code,
kle.oec,
kle.residual_code,
kle.capital_amount,
kle.delivered_date,
kle.date_funding_required,
kle.residual_grnty_amount,
kle.date_funding,
kle.residual_value,
kle.amount,
kle.price_negotiated,
kle.start_date,
kle.end_date,
kle.orig_system_id1,
kle.fee_type,
kle.initial_direct_cost,
tl.item_description,
tl.name
from okl_k_lines_full_v kle,
okc_line_styles_b lse,
okc_k_lines_tl tl,
okc_statuses_b sts
where KLE.LSE_ID = LSE.ID
and lse.lty_code IN ('FEE', 'SOLD_SERVICE', 'LINK_SERV_ASSET', 'FREE_FORM1', 'LINK_FEE_ASSET')
and tl.id = kle.id
and tl.language = userenv('LANG')
and kle.dnz_chr_id = p_chr_id
and sts.code = kle.sts_code
and sts.ste_code not in ('HOLD', 'TERMINATED', 'EXPIRED','CANCELLED');
select crl.id slh_id,
crl.object1_id1, --stream type id
crl.RULE_INFORMATION1,
crl.RULE_INFORMATION2,
crl.RULE_INFORMATION3,
crl.RULE_INFORMATION5,
crl.RULE_INFORMATION6,
crl.RULE_INFORMATION10
from OKC_RULE_GROUPS_B crg,
OKC_RULES_B crl
where crl.rgp_id = crg.id
and crg.RGD_CODE = 'LALEVL'
and crl.RULE_INFORMATION_CATEGORY = 'LASLH'
and crg.dnz_chr_id = chrId
and crg.cle_id = cleId
order by crl.RULE_INFORMATION1;
SELECT STREAM_TYPE_PURPOSE from okl_strm_type_b
where id = p_sty_id;
SELECT NVL(TO_NUMBER(rul.rule_information1), 100) pass_through_percentage
FROM okc_rule_groups_b rgp,
okc_rules_b rul
WHERE rgp.cle_id = kleid
AND rgp.rgd_code = 'LAPSTH'
AND rgp.id = rul.rgp_id
AND rul.rule_information_category = 'LAPTPR';
SELECT TO_NUMBER(rul.rule_information1) periods,
TO_NUMBER(rul.rule_information2) amount --,
FROM okc_rules_b rul,
okc_rules_b rul2,
okc_rule_groups_b rgp,
okc_k_lines_b cle,
okl_k_lines kle
WHERE rgp.dnz_chr_id = p_khr_id
AND rgp.cle_id = cle.id
AND kle.id = p_kle_id
AND cle.sts_code IN ('PASSED', 'COMPLETE')
AND kle.fee_type <> 'FINANCED'
AND kle.fee_type <> 'ABSORBED'
AND kle.fee_type <> 'ROLLOVER'
AND rgp.rgd_code = 'LAFEXP'
AND rgp.id = rul.rgp_id
AND rgp.id = rul2.rgp_id
AND rul.rule_information_category = 'LAFEXP'
AND rul2.rule_information_category = 'LAFREQ';
SELECT NVL(initial_direct_cost, 0)
FROM okl_k_lines
WHERE id = p_kle_id;
SELECT pdt_id, start_date
FROM okl_k_headers_full_v
WHERE id = l_khr_id;
SELECT
TLN.DEPENDENT_STY_ID,
STY1.NAME DEPENDENT_STY_NAME
FROM
OKL_ST_GEN_TMPT_LNS TLN,
OKL_ST_GEN_TEMPLATES TMPT,
OKL_ST_GEN_TMPT_SETS Tst,
OKL_AE_TMPT_SETS AES,
OKL_PRODUCTS_V PDT,
OKL_STRM_TYPE_v STY
, OKL_STRM_TYPE_v STY1
WHERE
TLN.GTT_ID = TMPT.ID AND
TMPT.GTS_ID = Tst.ID AND
Tst.ID = AES.GTS_ID AND
TST.deal_type = p_deal_type AND
AES.ID = PDT.AES_ID AND
TLN.PRIMARY_STY_ID = STY.ID AND
TLN.PRIMARY_STY_ID = p_primary_sty_id
AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
AND TLN.PRIMARY_YN = 'N'
AND PDT.ID = l_pdt_id
AND (TMPT.START_DATE <= l_contract_start_date)
AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
SELECT
TLN.DEPENDENT_STY_ID,
STY1.NAME DEPENDENT_STY_NAME
FROM
OKL_ST_GEN_TMPT_LNS TLN,
OKL_ST_GEN_TEMPLATES TMPT,
OKL_ST_GEN_TMPT_SETS Tst,
OKL_AE_TMPT_SETS AES,
OKL_PRODUCTS_V PDT,
OKL_STRM_TYPE_v STY
, OKL_STRM_TYPE_v STY1
WHERE
TLN.GTT_ID = TMPT.ID AND
TMPT.GTS_ID = Tst.ID AND
Tst.ID = AES.GTS_ID AND
TST.deal_type = p_deal_type AND
AES.ID = PDT.AES_ID AND
TLN.PRIMARY_STY_ID = STY.ID
AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
AND TLN.PRIMARY_YN = 'N'
AND PDT.ID = l_pdt_id
AND (TMPT.START_DATE <= l_contract_start_date)
AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
SELECT
TLN.DEPENDENT_STY_ID,
STY1.NAME DEPENDENT_STY_NAME
FROM
OKL_ST_GEN_TMPT_LNS TLN,
OKL_ST_GEN_TEMPLATES TMPT,
OKL_ST_GEN_TMPT_SETS Tst,
OKL_AE_TMPT_SETS AES,
OKL_PRODUCTS_V PDT,
OKL_STRM_TYPE_v STY
, OKL_STRM_TYPE_v STY1
WHERE
TLN.GTT_ID = TMPT.ID AND
TMPT.GTS_ID = Tst.ID AND
Tst.ID = AES.GTS_ID AND
TST.deal_type = p_deal_type AND
AES.ID = PDT.AES_ID AND
TLN.PRIMARY_STY_ID = STY.ID AND
TLN.PRIMARY_STY_ID = p_primary_sty_id
AND TLN.DEPENDENT_STY_ID = STY1.ID (+)
AND TLN.PRIMARY_YN = 'N'
AND PDT.ID = l_pdt_id
AND (TMPT.START_DATE <= l_contract_start_date)
AND (TMPT.END_DATE >= l_contract_start_date OR TMPT.END_DATE IS NULL)
AND STY1.STREAM_TYPE_PURPOSE = p_dependent_sty_purpose;
SELECT
tst.isg_arrears_pay_dates_option
FROM
okl_st_gen_tmpt_sets tst,
okl_ae_tmpt_sets_all aes,
okl_products_v pdt,
okl_k_headers khr
WHERE
khr.id = p_khr_id
AND pdt.id = khr.pdt_id
AND aes.id = pdt.aes_id
AND tst.id = aes.gts_id
;