DBA Data[Home] [Help]

APPS.OKL_VFA_PVT dependencies on OKC_K_LINES_B

Line 111: FROM okc_k_lines_b cle,

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

Line 124: ,okc_k_lines_b cle

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
127: AND cle.lse_id = t1.id
128: AND t2.lty_code = G_FIN_LINE_LTY_CODE