9357: FROM DUAL
9358: WHERE EXISTS (
9359: SELECT 1
9360: FROM okc_subclass_top_line stl,
9361: okc_line_styles_v lse,
9362: okc_k_lines_v cle,
9363: okc_k_headers_v khr
9364: WHERE cle.ID = p_top_line_id
9365: AND cle.dnz_chr_id = p_dnz_chr_id
12931: IS
12932: SELECT kle.ID ID
12933: FROM okc_k_lines_v kle,
12934: okc_k_headers_v khr,
12935: okc_line_styles_v lse
12936: WHERE kle.dnz_chr_id = p_khr_id
12937: AND kle.dnz_chr_id = khr.ID
12938: AND kle.sts_code = khr.sts_code
12939: AND kle.lse_id = lse.ID