APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_LINE_STYLES_B

Line 678: FROM okc_line_styles_b

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

Line 684: -- FROM okc_line_styles_b

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

Line 691: okc_line_styles_b lse

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

Line 702: okc_line_styles_b lse

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

Line 713: FROM okc_line_styles_b lse

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

Line 3774: FROM okc_line_styles_b

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

Line 6063: okc_line_styles_b lse

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

Line 6070: okc_line_styles_b lse

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