47: FROM DUAL
48: WHERE EXISTS (SELECT t1.id
49: FROM okc_line_styles_b t1
50: ,okc_line_styles_b t2
51: ,okc_subclass_top_line t3
52: ,okc_k_lines_b cle
53: WHERE t1.lty_code = p_code
54: AND cle.id = p_cle_id
55: AND cle.lse_id = t1.id
66: WHERE EXISTS (SELECT t1.id
67: FROM okc_line_styles_b t1
68: ,okc_line_styles_b t2
69: ,okc_line_styles_b t3
70: ,okc_subclass_top_line t4
71: ,okc_k_lines_b cle
72: WHERE t1.lty_code = p_code
73: AND cle.id = p_cle_id
74: AND cle.lse_id = t1.id
207: FROM DUAL
208: WHERE EXISTS (SELECT t1.id
209: FROM okc_line_styles_b t1
210: ,okc_line_styles_b t2
211: ,okc_subclass_top_line t3
212: ,okc_k_lines_b cle
213: WHERE t1.lty_code = p_code
214: AND cle.id = p_cle_id
215: AND cle.lse_id = t1.id