APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_K_LINES_V

Line 153: FROM OKC_K_LINES_V A,

149: x_msg_data OUT NOCOPY VARCHAR2) IS
150:
151: CURSOR c_free_form2(p_parent_line_id IN NUMBER) IS
152: SELECT A.ID
153: FROM OKC_K_LINES_V A,
154: OKC_LINE_STYLES_B B
155: WHERE A.CLE_ID = p_parent_line_id
156: AND A.LSE_ID = B.ID
157: AND B.LTY_CODE = 'FREE_FORM2';

Line 162: FROM OKC_K_LINES_V A,

158:
159: CURSOR c_inst_item(p_line_id IN NUMBER) IS
160: SELECT A.ID,
161: A.DNZ_CHR_ID
162: FROM OKC_K_LINES_V A,
163: OKC_LINE_STYLES_B B
164: WHERE A.CLE_ID = p_line_id
165: AND A.LSE_ID = B.ID
166: AND B.LTY_CODE = 'INST_ITEM';

Line 239: FROM okc_k_lines_v kle,

235: CURSOR c_get_chr_id (p_kle_id IN NUMBER) IS
236: SELECT kle.dnz_chr_id,
237: khr.org_id,
238: khr.currency_code
239: FROM okc_k_lines_v kle,
240: okc_k_headers_all_b khr
241: WHERE kle.id = p_kle_id
242: AND kle.dnz_chr_id = khr.id;
243:

Line 260: FROM okc_k_lines_v okcl,

256: AND line.cle_id = p_line_id;
257:
258: CURSOR c_get_ast_instances(p_parent_line_id IN NUMBER) IS
259: SELECT count(*)
260: FROM okc_k_lines_v okcl,
261: okc_line_styles_v lse
262: WHERE okcl.cle_id = p_parent_line_id
263: AND okcl.lse_id = lse.id
264: AND lse.lty_code = 'FREE_FORM2';

Line 1727: FROM OKC_K_LINES_V A,

1723: x_msg_data OUT NOCOPY VARCHAR2) IS
1724:
1725: CURSOR c_free_form2(p_parent_line_id IN NUMBER) IS
1726: SELECT A.ID, K.org_id
1727: FROM OKC_K_LINES_V A,
1728: OKC_LINE_STYLES_B B,
1729: okc_k_headers_all_b K
1730: WHERE A.CLE_ID = p_parent_line_id
1731: AND A.LSE_ID = B.ID

Line 1738: FROM OKC_K_LINES_V A,

1734:
1735: CURSOR c_inst_item(p_line_id IN NUMBER) IS
1736: SELECT A.ID,
1737: A.DNZ_CHR_ID
1738: FROM OKC_K_LINES_V A,
1739: OKC_LINE_STYLES_B B
1740: WHERE A.CLE_ID = p_line_id
1741: AND A.LSE_ID = B.ID
1742: AND B.LTY_CODE = 'INST_ITEM';