DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_SUBCLASS_TOP_LINE_V

Line 689: FROM okc_subclass_top_line_v stl,

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;

Line 700: FROM okc_subclass_top_line_v stl,

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