DBA Data[Home] [Help]

APPS.OKL_VIB_PVT dependencies on OKC_K_LINES_B

Line 110: FROM okc_k_lines_b cle,

106: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
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:

Line 126: ,okc_k_lines_b cle

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
129: AND cle.lse_id = t1.id
130: AND t2.lty_code = p_code2