APPS.OKL_BLK_AST_UPD_PVT dependencies on OKC_K_LINES_V

Line 185: FROM OKC_K_LINES_V A,

181: x_msg_data OUT NOCOPY VARCHAR2) IS
182:
183: CURSOR c_free_form2(p_parent_line_id IN NUMBER) IS
184: SELECT A.ID
185: FROM OKC_K_LINES_V A,
186: OKC_LINE_STYLES_B B
187: WHERE A.CLE_ID = p_parent_line_id
188: AND A.LSE_ID = B.ID
189: AND B.LTY_CODE = 'FREE_FORM2';

Line 194: FROM OKC_K_LINES_V A,

190:
191: CURSOR c_inst_item(p_line_id IN NUMBER) IS
192: SELECT A.ID,
193: A.DNZ_CHR_ID
194: FROM OKC_K_LINES_V A,
195: OKC_LINE_STYLES_B B
196: WHERE A.CLE_ID = p_line_id
197: AND A.LSE_ID = B.ID
198: AND B.LTY_CODE = 'INST_ITEM';

Line 271: FROM okc_k_lines_v kle,

267: CURSOR c_get_chr_id (p_kle_id IN NUMBER) IS
268: SELECT kle.dnz_chr_id,
269: khr.org_id,
270: khr.currency_code
271: FROM okc_k_lines_v kle,
272: okc_k_headers_all_b khr
273: WHERE kle.id = p_kle_id
274: AND kle.dnz_chr_id = khr.id;
275:

Line 292: FROM okc_k_lines_v okcl,

288: AND line.cle_id = p_line_id;
289:
290: CURSOR c_get_ast_instances(p_parent_line_id IN NUMBER) IS
291: SELECT count(*)
292: FROM okc_k_lines_v okcl,
293: okc_line_styles_v lse
294: WHERE okcl.cle_id = p_parent_line_id
295: AND okcl.lse_id = lse.id
296: AND lse.lty_code = 'FREE_FORM2';

Line 1759: FROM OKC_K_LINES_V A,

1755: x_msg_data OUT NOCOPY VARCHAR2) IS
1756:
1757: CURSOR c_free_form2(p_parent_line_id IN NUMBER) IS
1758: SELECT A.ID, K.org_id
1759: FROM OKC_K_LINES_V A,
1760: OKC_LINE_STYLES_B B,
1761: okc_k_headers_all_b K
1762: WHERE A.CLE_ID = p_parent_line_id
1763: AND A.LSE_ID = B.ID

Line 1770: FROM OKC_K_LINES_V A,

1766:
1767: CURSOR c_inst_item(p_line_id IN NUMBER) IS
1768: SELECT A.ID,
1769: A.DNZ_CHR_ID
1770: FROM OKC_K_LINES_V A,
1771: OKC_LINE_STYLES_B B
1772: WHERE A.CLE_ID = p_line_id
1773: AND A.LSE_ID = B.ID
1774: AND B.LTY_CODE = 'INST_ITEM';