[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select nvl( total_principal_amount, -1) princi
from okl_pools
where khr_id = chrID;
Select count(*) cnt
From okc_k_headers_v where contract_number = n;
SELECT distinct pool.khr_id, pcon.sty_id, pcon.sty_code
FROM okl_pools pool, okl_pool_contents pcon
WHERE pool.id = pcon.pol_id
AND pool.khr_id = p_chr_id
AND not exists (
SELECT 'Y'
FROM okc_line_styles_b rev_style,
okl_k_lines revl,
okc_k_lines_b rev
WHERE rev.lse_id = rev_style.id
AND rev_style.lty_code = 'REVENUE_SHARE'
AND revl.id = rev.id
AND revl.sty_id = pcon.sty_id
AND rev.cle_id = p_cle_id );
SELECT rev.id, rev.cle_id, revl.sty_id,revl.percent_stake,
strm.stream_type_subclass
FROM okc_line_styles_b rev_style,
okl_k_lines revl,
okc_k_lines_b rev,
okl_strm_type_v strm
WHERE rev.lse_id = rev_style.id
AND rev_style.lty_code = 'REVENUE_SHARE'
AND revl.id = rev.id
AND rev.cle_id = p_cle_id
AND revl.sty_id = strm.id
ORDER BY strm.stream_type_subclass;
SELECT tl.name name,
stm.stream_type_class stream_type_class,
stm.stream_type_subclass stream_type_subclass,
tl.description ALLOC_BASIS,
stm.capitalize_yn capitalize_yn,
stm.periodic_yn periodic_yn
FROM okl_strm_type_b stm,
OKL_STRM_TYPE_TL tl
WHERE tl.id = stm.id
and tl.language = 'US'
and stm.id = styid;
SELECT name, stream_type_subclass
FROM okl_strm_type_v strm
WHERE stream_type_subclass = 'INVESTOR_DISBURSEMENT'
AND not exists (
SELECT 'Y'
FROM okc_line_styles_b rev_style,
okl_k_lines revl,
okc_k_lines_b rev
WHERE rev.lse_id = rev_style.id
AND rev_style.lty_code = 'REVENUE_SHARE'
AND revl.id = rev.id
AND revl.sty_id = strm.id
AND rev.cle_id = p_cle_id);
SELECT fnd.meaning
FROM fnd_lookups fnd
WHERE fnd.lookup_type = p_lookup_type
AND fnd.lookup_code = p_lookup_code;
SELECT 1
FROM okl_k_lines kleb,
okc_k_lines_b cles,
okc_line_styles_b lseb
WHERE kleb.id = cles.id
AND cles.lse_id = lseb.id
AND cles.cle_id = p_investor_id
AND lseb.lty_code = 'REVENUE_SHARE'
AND kleb.stream_type_subclass = p_stream_type_subclass;
SELECT 1
FROM okl_pool_contents pocb,
okl_pools polb,
okl_strm_type_b styb
WHERE polb.khr_id = p_agreement_id
AND pocb.pol_id = polb.id
AND pocb.sty_id = styb.id
AND styb.stream_type_subclass = p_stream_type_subclass;
SELECT kleb.percent_stake
FROM okl_k_lines kleb,
okc_k_lines_b cles,
okc_line_styles_b lseb
WHERE kleb.id = cles.id
AND cles.lse_id = lseb.id
AND cles.cle_id = p_investor_id
AND lseb.lty_code = 'REVENUE_SHARE'
AND kleb.stream_type_subclass = p_stream_type_subclass;
select hzp.party_name partyname
, okl_strmtyp.name streamtypename
FROM okc_k_lines_b cle
, okc_line_styles_b lse
, okl_k_lines kle
, okc_k_party_roles_b parb
, hz_parties hzp
, okc_k_items cit
, okl_strmtyp_source_v okl_strmtyp
WHERE lse.id = cle.lse_id
AND kle.id = cle.id
and kle.fee_type='INCOME'
AND lse.lty_code = 'FEE'
AND cit.dnz_chr_id = cle.dnz_chr_id
AND cle.sts_code <> ('ABANDONED')
AND cit.cle_id = cle.id
AND to_char(okl_strmtyp.id1) = cit.object1_id1
AND to_char(okl_strmtyp.id2) = cit.object1_id2
AND parb.cle_id = cle.id
and hzp.party_id=parb.OBJECT1_ID1
and cle.dnz_chr_id = p_agreement_id
AND not EXISTS(
SELECT 1
from okc_rule_groups_b rgp
, okc_rules_b rule
where rgp.id = rule.rgp_id
and rgp.rgd_code = 'LALEVL'
and rgp.dnz_chr_id = p_agreement_id
and rule.rule_information_category = 'LASLL'
AND rgp.cle_id = cle.id);
SELECT kleb.stream_type_subclass,
kleb.percent_stake
FROM okl_k_lines kleb,
okc_k_lines_b cles,
okc_line_styles_b lseb
WHERE kleb.id = cles.id
AND cles.lse_id = lseb.id
AND cles.cle_id = p_investor_id
AND lseb.lty_code = 'REVENUE_SHARE';
SELECT DISTINCT(poc.khr_id)
FROM okl_pool_contents poc, okl_pools pol
WHERE pol.khr_id = p_chr_id
AND pol.id = poc.pol_id;
SELECT a.khr_id,
decode(c.securitization_type, 'SALE','SECURITIZATION','LOAN','SYNDICATION',
'SECURITIZATION','SECURITIZATION','SYNDICATION','SYNDICATION') securitization_type,
b.contract_number
FROM okl_pool_contents a, okc_k_headers_b b,okl_k_headers c, okl_pools d
WHERE a.khr_id = p_khr_id
AND a.pol_id=d.id
AND d.khr_id= c.id
AND b.id=c.id;