APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_LINE_STYLES_B

Line 677: FROM okc_line_styles_b

673: -- Getting recursive flag for line styles
674:
675: CURSOR c_lty_code IS
676: SELECT lty_code,recursive_yn
677: FROM okc_line_styles_b
678: WHERE id = p_old_lse_id;
679:
680: -- Commented for Bug 1993566
681: -- CURSOR c_lty_code IS

Line 683: -- FROM okc_line_styles_b

679:
680: -- Commented for Bug 1993566
681: -- CURSOR c_lty_code IS
682: -- SELECT lty_code,recursive_yn
683: -- FROM okc_line_styles_b
684: -- WHERE id = p_old_lse_id;
685:
686: /*
687: CURSOR c_top_lse_lty(p_lty_code IN VARCHAR2) IS

Line 690: okc_line_styles_b lse

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;
694: */

Line 701: okc_line_styles_b lse

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
705: AND stl.scs_code = p_new_subclass

Line 712: FROM okc_line_styles_b lse

708: -- end added by Sanjay for bug # 1923216
709:
710: CURSOR c_sub_lse_lty(p_lty_code IN VARCHAR2) IS
711: SELECT lse.id
712: FROM okc_line_styles_b lse
713: WHERE lse.lty_code = p_lty_code
714: AND lse.lse_parent_id = p_new_parent_lse;
715:
716: FUNCTION get_source(p_lse_id IN NUMBER) RETURN VARCHAR2 IS

Line 3773: FROM okc_line_styles_b

3769:
3770: CURSOR c_lse(p_id IN NUMBER) IS
3771: SELECT lty_code,
3772: priced_yn
3773: FROM okc_line_styles_b
3774: WHERE id = p_id;
3775:
3776: CURSOR c_cim(p_cle_id IN NUMBER) IS
3777: SELECT id

Line 6062: okc_line_styles_b lse

6058:
6059: CURSOR c_lines IS
6060: SELECT cle.id,lse.lty_code
6061: FROM okc_k_lines_b cle,
6062: okc_line_styles_b lse
6063: WHERE chr_id = p_chr_id
6064: AND cle.lse_id= lse.id
6065: AND g_copy_history_yn = 'N'
6066: UNION ALL

Line 6069: okc_line_styles_b lse

6065: AND g_copy_history_yn = 'N'
6066: UNION ALL
6067: SELECT cle.id,lse.lty_code
6068: FROM okc_k_lines_bh cle,
6069: okc_line_styles_b lse
6070: WHERE chr_id = p_chr_id
6071: AND cle.lse_id= lse.id
6072: AND major_version = G_FROM_VERSION_NUMBER
6073: AND G_COPY_HISTORY_YN = 'Y';