DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_SECTIONS_BH

Line 294: DELETE FROM OKC_SECTIONS_BH

290: WHERE document_type=l_doc_type_tbl(i)
291: and document_id=l_doc_id_tbl(i);
292:
293: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST
294: DELETE FROM OKC_SECTIONS_BH
295: WHERE document_type=l_doc_type_tbl(i)
296: and document_id=l_doc_id_tbl(i);
297:
298: FORALL i IN l_doc_type_tbl.FIRST..l_doc_type_tbl.LAST

Line 1604: FROM OKC_SECTIONS_BH

1600: AND DOCUMENT_ID=p_doc_id;
1601:
1602: Cursor l_get_max_scn_hist_date_csr IS
1603: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1604: FROM OKC_SECTIONS_BH
1605: WHERE DOCUMENT_TYPE=p_doc_type
1606: AND DOCUMENT_ID=p_doc_id;
1607:
1608: Cursor l_get_contract_source_csr IS