[Home] [Help]
1881: CURSOR k_lines_csr(p_khr_id IN NUMBER) IS
1882: SELECT OKLV.id kle_id,
1883: OKLV.name asset_name
1884: FROM OKC_K_LINES_V OKLV,
1885: OKC_LINE_STYLES_V OLSV,
1886: OKC_K_HEADERS_V KHR
1887: WHERE OKLV.chr_id = p_khr_id
1888: AND OKLV.lse_id = OLSV.id
1889: AND OLSV.lty_code = 'FREE_FORM1'
6518: CURSOR k_asst_fee_srvc_lns_csr(p_khr_id IN NUMBER) IS
6519: SELECT oklv.id kle_id,
6520: oklv.NAME asset_name
6521: FROM okc_k_lines_v oklv,
6522: okc_line_styles_v olsv,
6523: okc_k_headers_v khr
6524: WHERE oklv.chr_id = p_khr_id AND oklv.lse_id = olsv.id AND
6525: olsv.lty_code IN
6526: ('FREE_FORM1', 'FEE', 'SOLD_SERVICE') AND