APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_K_ART_VARIABLES

Line 265: DELETE FROM OKC_K_ART_VARIABLES

261:
262: IF l_doc_type_tbl.COUNT > 0 THEN
263:
264: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
265: DELETE FROM OKC_K_ART_VARIABLES
266: WHERE cat_id IN
267: ( SELECT ID FROM OKC_K_ARTICLES_B
268: WHERE document_type=l_doc_type_tbl(i)
269: and document_id=l_doc_id_tbl(i));

Line 272: DELETE FROM OKC_K_ART_VARIABLES_H

268: WHERE document_type=l_doc_type_tbl(i)
269: and document_id=l_doc_id_tbl(i));
270:
271: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
272: DELETE FROM OKC_K_ART_VARIABLES_H
273: WHERE cat_id IN
274: ( SELECT ID FROM OKC_K_ARTICLES_BH
275: WHERE document_type=l_doc_type_tbl(i)
276: and document_id=l_doc_id_tbl(i));

Line 421: from okc_k_art_variables var, okc_k_articles_b kart

417: i BINARY_INTEGER;
418:
419: CURSOR var_codes_crs IS
420: select distinct var.variable_code
421: from okc_k_art_variables var, okc_k_articles_b kart
422: where kart.document_type = p_doc_type
423: and kart.document_id = p_doc_id
424: and kart.amendment_Operation_code is null
425: and kart.id=var.cat_id