[Home] [Help]
99: select ulvb.id id1,
100: '#' id2,
101: ulv.name,
102: ulv.item_description description
103: from okc_k_lines_b ulvb,
104: okc_k_lines_tl ulv
105: where ulv.name = p_name
106: and ulvb.id = nvl(p_id1,ulvb.id)
107: and '#' = nvl(p_id2,'#')
2373: CURSOR get_lty_code_csr(p_chr_id NUMBER,
2374: p_cle_id NUMBER) IS
2375: SELECT lty_code
2376: FROM okc_line_styles_b lse,
2377: okc_k_lines_b cle
2378: WHERE lse.lse_parent_id = cle.lse_id
2379: AND cle.id = p_cle_id
2380: AND cle.chr_id = p_chr_id;
2381:
3456:
3457: select count(1)
3458:
3459: from okc_k_items cim
3460: , okc_k_lines_b cle
3461: , okc_line_style_sources lss
3462: , okc_line_styles_b lse
3463: where nvl(lss.start_date,sysdate) <= sysdate
3464: and nvl(lss.end_date,sysdate + 1) > sysdate
3475:
3476: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
3477: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
3478: from okc_k_items cim
3479: , okc_k_lines_b cle
3480: , okc_line_style_sources lss
3481: , okc_line_styles_b lse
3482: where nvl(lss.start_date,sysdate) <= sysdate
3483: and nvl(lss.end_date,sysdate + 1) > sysdate
5029:
5030: select count(1)
5031:
5032: from okc_k_items cim
5033: , okc_k_lines_b cle
5034: , okc_line_style_sources lss
5035: , okc_line_styles_b lse
5036: where nvl(lss.start_date,sysdate) <= sysdate
5037: and nvl(lss.end_date,sysdate + 1) > sysdate
5049: CURSOR get_item_csr(p_chr_id NUMBER, p_cle_id NUMBER) IS
5050:
5051: SELECT lse.lty_code, cim.object1_id1, cim.object1_id2
5052: from okc_k_items cim
5053: , okc_k_lines_b cle
5054: , okc_line_style_sources lss
5055: , okc_line_styles_b lse
5056: where nvl(lss.start_date,sysdate) <= sysdate
5057: and nvl(lss.end_date,sysdate + 1) > sysdate
7271:
7272: l_rollover_yn varchar2(1) := null;
7273: cursor l_rollover_fee_csr is
7274: select 'Y'
7275: from okc_k_lines_b cle,
7276: okl_k_lines kle
7277: where cle.id = kle.id
7278: and cle.dnz_chr_id = p_chr_id
7279: and cle.chr_id = p_chr_id