DBA Data[Home] [Help]

APPS.OKL_VFA_PVT dependencies on OKC_LINE_STYLES_B

Line 112: okc_line_styles_b lse

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

Line 121: FROM okc_line_styles_b t1

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

Line 122: ,okc_line_styles_b t2

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