APPS.OKL_SID_PVT dependencies on OKC_LINE_STYLES_B

Line 40: okc_line_styles_b lse

36:
37: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
38: SELECT lse.lty_code
39: FROM okc_k_lines_b cle,
40: okc_line_styles_b lse
41: WHERE cle.id = p_cle_id
42: AND cle.lse_id = lse.id;
43:
44: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

Line 49: FROM okc_line_styles_b t1

45: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
46: SELECT 1
47: FROM DUAL
48: WHERE EXISTS (SELECT t1.id
49: FROM okc_line_styles_b t1
50: ,okc_line_styles_b t2
51: ,okc_subclass_top_line t3
52: ,okc_k_lines_b cle
53: WHERE t1.lty_code = p_code

Line 50: ,okc_line_styles_b t2

46: SELECT 1
47: FROM DUAL
48: WHERE EXISTS (SELECT t1.id
49: FROM okc_line_styles_b t1
50: ,okc_line_styles_b t2
51: ,okc_subclass_top_line t3
52: ,okc_k_lines_b cle
53: WHERE t1.lty_code = p_code
54: AND cle.id = p_cle_id

Line 67: FROM okc_line_styles_b t1

63: p_code2 IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
64: SELECT 1
65: FROM DUAL
66: WHERE EXISTS (SELECT t1.id
67: FROM okc_line_styles_b t1
68: ,okc_line_styles_b t2
69: ,okc_line_styles_b t3
70: ,okc_subclass_top_line t4
71: ,okc_k_lines_b cle

Line 68: ,okc_line_styles_b t2

64: SELECT 1
65: FROM DUAL
66: WHERE EXISTS (SELECT t1.id
67: FROM okc_line_styles_b t1
68: ,okc_line_styles_b t2
69: ,okc_line_styles_b t3
70: ,okc_subclass_top_line t4
71: ,okc_k_lines_b cle
72: WHERE t1.lty_code = p_code

Line 69: ,okc_line_styles_b t3

65: FROM DUAL
66: WHERE EXISTS (SELECT t1.id
67: FROM okc_line_styles_b t1
68: ,okc_line_styles_b t2
69: ,okc_line_styles_b t3
70: ,okc_subclass_top_line t4
71: ,okc_k_lines_b cle
72: WHERE t1.lty_code = p_code
73: AND cle.id = p_cle_id

Line 200: okc_line_styles_b lse

196:
197: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
198: SELECT lse.lty_code
199: FROM okc_k_lines_b cle,
200: okc_line_styles_b lse
201: WHERE cle.id = p_cle_id
202: AND cle.lse_id = lse.id;
203:
204: CURSOR c_cle_id_validate1(p_cle_id IN OKC_K_LINES_V.ID%TYPE,

Line 209: FROM okc_line_styles_b t1

205: p_code IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
206: SELECT 1
207: FROM DUAL
208: WHERE EXISTS (SELECT t1.id
209: FROM okc_line_styles_b t1
210: ,okc_line_styles_b t2
211: ,okc_subclass_top_line t3
212: ,okc_k_lines_b cle
213: WHERE t1.lty_code = p_code

Line 210: ,okc_line_styles_b t2

206: SELECT 1
207: FROM DUAL
208: WHERE EXISTS (SELECT t1.id
209: FROM okc_line_styles_b t1
210: ,okc_line_styles_b t2
211: ,okc_subclass_top_line t3
212: ,okc_k_lines_b cle
213: WHERE t1.lty_code = p_code
214: AND cle.id = p_cle_id