[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT kle.id,
kle.initial_direct_cost
FROM okl_k_lines kle,
okc_k_lines_b cle,
okc_line_styles_b lse
WHERE cle.chr_id = p_khr_id
AND cle.sts_code IN ('PASSED', 'COMPLETE')
AND cle.lse_id = lse.id
AND lse.lty_code = 'FEE'
AND kle.fee_type <> 'FINANCED'
AND kle.fee_type <> 'ROLLOVER'
AND cle.id = kle.id;
SELECT sel.amount income_amount,
sel.stream_element_date income_date
FROM okl_strm_elements sel,
okl_streams stm,
okl_strm_type_b sty,
okl_strm_type_tl styt
WHERE stm.khr_id = p_khr_id
AND stm.say_code = 'WORK'
AND DECODE(stm.purpose_code, NULL, '-99', 'REPORT') = p_purpose_code
AND stm.id = sel.stm_id
AND stm.sty_id = sty.id
AND sty.version = '1.0'
AND sty.id = styt.id
AND styt.language = 'US'
AND styt.name = p_sty_name
ORDER BY sel.stream_element_date;
Select distinct nvl(slh.object1_id1, -1) styId
From OKC_RULE_GROUPS_B rgp,
OKC_RULES_B sll,
okc_rules_b slh,
okl_strm_type_b sty
Where slh.rgp_id = rgp.id
and rgp.RGD_CODE = 'LALEVL'
and sll.RULE_INFORMATION_CATEGORY = 'LASLL'
and slh.RULE_INFORMATION_CATEGORY = 'LASLH'
AND TO_CHAR(slh.id) = sll.object2_id1
and slh.object1_id1 = sty.id
and sty.stream_type_purpose = 'RENT'
and rgp.dnz_chr_id = p_khr_id;
select tl.name strm_name,
sty.capitalize_yn capitalize_yn,
kle.id line_id,
sty.id styp_id,
sty.stream_type_class stream_type_class
from okl_strm_type_tl tl,
okl_strm_type_v sty,
okc_k_items cim,
okl_k_lines_full_v kle,
okc_line_styles_b ls
where tl.id = sty.id
and tl.language = 'US'
and cim.cle_id = kle.id
and ls.id = kle.lse_id
and ls.lty_code = 'FEE'
and cim.object1_id1 = sty.id
and cim.object1_id2 = '#'
and kle.id = kleid;
SELECT okl_sif_seq.nextval
INTO l_stmv_rec.transaction_number
FROM DUAL;
l_selv_tbl.DELETE;
l_selv_tbl.DELETE;
select tl.name strm_name,
sty.capitalize_yn capitalize_yn,
kle.id line_id,
sty.id styp_id,
sty.stream_type_class stream_type_class
from okl_strm_type_tl tl,
okl_strm_type_v sty,
okc_k_items cim,
okl_k_lines_full_v kle,
okc_line_styles_b ls
where tl.id = sty.id
and tl.language = 'US'
and cim.cle_id = kle.id
and ls.id = kle.lse_id
and ls.lty_code = 'FEE'
and cim.object1_id1 = sty.id
and cim.object1_id2 = '#'
and kle.id = kleid;
SELECT TO_NUMBER(rul.rule_information1) periods,
TO_NUMBER(rul.rule_information2) amount,
DECODE(rul2.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12, NULL) mpp,
rgp.cle_id,
cle.start_date,
cle.sts_code
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 = cle.id
AND cle.sts_code IN ('NEW', 'INCOMPLETE', '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 DAYS_IN_A_YEAR_CODE,
DAYS_IN_A_MONTH_CODE
from OKL_K_RATE_PARAMS
where khr_id = khrId;
SELECT to_char(pdt.id) pid,
chr.scs_code,
pdt.reporting_pdt_id -- R12.1.2
FROM okc_k_headers_v chr,
okl_k_headers khr,
okl_products_v pdt
WHERE khr.id = chr.id
AND chr.id = p_khr_id
AND khr.pdt_id = pdt.id(+);
SELECT okl_sif_seq.nextval
INTO l_stmv_rec.transaction_number
FROM DUAL;
l_selv_tbl.DELETE;
l_selv_tbl.DELETE;
SELECT chr.start_date,
chr.end_date,
chr.currency_code
FROM okc_k_headers_b chr
WHERE chr.id = p_khr_id;