APPS.OKL_VIB_PVT dependencies on OKC_LINE_STYLES_B

Line 111: okc_line_styles_b lse

107:
108: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
109: SELECT lse.lty_code
110: FROM okc_k_lines_b cle,
111: okc_line_styles_b lse
112: WHERE cle.id = p_cle_id
113: AND cle.lse_id = lse.id;
114:
115:

Line 122: FROM okc_line_styles_b t1

118: p_code2 IN OKC_LINE_STYLES_V.LTY_CODE%TYPE) IS
119: SELECT 1
120: FROM DUAL
121: WHERE EXISTS (SELECT t1.id
122: FROM okc_line_styles_b t1
123: ,okc_line_styles_b t2
124: ,okc_line_styles_b t3
125: ,okc_subclass_top_line t4
126: ,okc_k_lines_b cle

Line 123: ,okc_line_styles_b t2

119: SELECT 1
120: FROM DUAL
121: WHERE EXISTS (SELECT t1.id
122: FROM okc_line_styles_b t1
123: ,okc_line_styles_b t2
124: ,okc_line_styles_b t3
125: ,okc_subclass_top_line t4
126: ,okc_k_lines_b cle
127: WHERE t1.lty_code = p_code

Line 124: ,okc_line_styles_b t3

120: FROM DUAL
121: WHERE EXISTS (SELECT t1.id
122: FROM okc_line_styles_b t1
123: ,okc_line_styles_b t2
124: ,okc_line_styles_b t3
125: ,okc_subclass_top_line t4
126: ,okc_k_lines_b cle
127: WHERE t1.lty_code = p_code
128: AND cle.id = p_cle_id