APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_K_ARTICLES_BH

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 356: ( SELECT ID FROM OKC_K_ARTICLES_BH

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));
359:
360: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 366: DELETE FROM OKC_K_ARTICLES_BH

362: WHERE document_type=l_doc_type_tbl(i)
363: and document_id=l_doc_id_tbl(i);
364:
365: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
366: DELETE FROM OKC_K_ARTICLES_BH
367: WHERE document_type=l_doc_type_tbl(i)
368: and document_id=l_doc_id_tbl(i);
369:
370: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 1702: FROM OKC_K_ARTICLES_BH

1698: AND DOCUMENT_ID=p_doc_id;
1699:
1700: Cursor l_get_max_art_hist_date_csr IS
1701: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1702: FROM OKC_K_ARTICLES_BH
1703: WHERE DOCUMENT_TYPE=p_doc_type
1704: AND DOCUMENT_ID=p_doc_id;
1705:
1706: Cursor l_get_max_scn_hist_date_csr IS