APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_SECTIONS_B

Line 371: DELETE FROM OKC_SECTIONS_B

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
371: DELETE FROM OKC_SECTIONS_B
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

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 1696: FROM OKC_SECTIONS_B

1692: AND DOCUMENT_ID=p_doc_id;
1693:
1694: Cursor l_get_max_scn_date_csr IS
1695: SELECT max(Nvl(LAST_AMENDMENT_DATE,CREATION_DATE))
1696: FROM OKC_SECTIONS_B
1697: WHERE DOCUMENT_TYPE=p_doc_type
1698: AND DOCUMENT_ID=p_doc_id;
1699:
1700: Cursor l_get_max_art_hist_date_csr IS

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

Line 4413: From okc_sections_b

4409:
4410: CURSOR cur_sec_details (cp_kart_sec_id IN NUMBER)
4411: IS
4412: SELECT orig_system_reference_code, orig_system_reference_id1, document_type,document_id
4413: From okc_sections_b
4414: Where id= cp_kart_sec_id ;
4415: l_tgt_sec_details_rec cur_sec_details%ROWTYPE;
4416: l_src_sec_details_rec cur_sec_details%ROWTYPE;
4417: