APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_K_ART_VARIABLES_H

Line 334: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

330:
331: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
332: DELETE FROM OKC_K_ART_VAR_EXT_TLH
333: WHERE cat_id IN
334: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
335: WHERE document_type=l_doc_type_tbl(i)
336: and document_id=l_doc_id_tbl(i)
337: AND BUSVAR.mrv_flag='Y'
338: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE

Line 345: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR

341:
342: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
343: DELETE FROM OKC_K_ART_VAR_EXT_BH
344: WHERE cat_id IN
345: ( SELECT KART.ID FROM OKC_K_ARTICLES_BH KART, OKC_K_ART_VARIABLES_H ARTVAR, OKC_BUS_VARIABLES_B BUSVAR
346: WHERE document_type=l_doc_type_tbl(i)
347: and document_id=l_doc_id_tbl(i)
348: AND BUSVAR.mrv_flag='Y'
349: AND ARTVAR.VARIABLE_CODE=BUSVAR.VARIABLE_CODE

Line 354: DELETE FROM OKC_K_ART_VARIABLES_H

350: AND ARTVAR.CAT_ID=KART.ID);
351:
352:
353: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
354: DELETE FROM OKC_K_ART_VARIABLES_H
355: WHERE cat_id IN
356: ( SELECT ID FROM OKC_K_ARTICLES_BH
357: WHERE document_type=l_doc_type_tbl(i)
358: and document_id=l_doc_id_tbl(i));