DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_SECTIONS_BH

Line 376: DELETE FROM OKC_SECTIONS_BH

372: WHERE document_type=l_doc_type_tbl(i)
373: and document_id=l_doc_id_tbl(i);
374:
375: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
376: DELETE FROM OKC_SECTIONS_BH
377: WHERE document_type=l_doc_type_tbl(i)
378: and document_id=l_doc_id_tbl(i);
379:
380: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 1708: FROM OKC_SECTIONS_BH

1704: AND DOCUMENT_ID=p_doc_id;
1705:
1706: Cursor l_get_max_scn_hist_date_csr IS
1707: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1708: FROM OKC_SECTIONS_BH
1709: WHERE DOCUMENT_TYPE=p_doc_type
1710: AND DOCUMENT_ID=p_doc_id;
1711:
1712: Cursor l_get_contract_source_csr IS