685:
686: /*
687: CURSOR c_top_lse_lty(p_lty_code IN VARCHAR2) IS
688: SELECT lse.id
689: FROM okc_subclass_top_line_v stl,
690: okc_line_styles_b lse
691: WHERE stl.lse_id = lse.id
692: AND lse.lty_code = p_lty_code
693: AND stl.scs_code = p_new_subclass;
696: -- added Sanjay for bug # 1923216
697:
698: CURSOR c_top_lse_lty(p_lty_code IN VARCHAR2) IS
699: SELECT lse.id
700: FROM okc_subclass_top_line_v stl,
701: okc_line_styles_b lse
702: WHERE stl.lse_id = lse.id
703: AND lse.id = p_old_lse_id -- added
704: AND lse.lty_code = p_lty_code