DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_SUBCLASS_TOP_LINE_V

Line 690: FROM okc_subclass_top_line_v stl,

686:
687: /*
688: CURSOR c_top_lse_lty(p_lty_code IN VARCHAR2) IS
689: SELECT lse.id
690: FROM okc_subclass_top_line_v stl,
691: okc_line_styles_b lse
692: WHERE stl.lse_id = lse.id
693: AND lse.lty_code = p_lty_code
694: AND stl.scs_code = p_new_subclass;

Line 701: FROM okc_subclass_top_line_v stl,

697: -- added Sanjay for bug # 1923216
698:
699: CURSOR c_top_lse_lty(p_lty_code IN VARCHAR2) IS
700: SELECT lse.id
701: FROM okc_subclass_top_line_v stl,
702: okc_line_styles_b lse
703: WHERE stl.lse_id = lse.id
704: AND lse.id = p_old_lse_id -- added
705: AND lse.lty_code = p_lty_code