DBA Data[Home] [Help]

APPS.OKC_CONTRACT_DOCS_GRP dependencies on OKC_BUS_DOC_TYPES_B

Line 1778: FROM okc_bus_doc_types_b

1774:
1775: CURSOR doc_version_view_name_csr (l_from_bus_doc_type VARCHAR2) IS
1776: SELECT
1777: doc_version_view
1778: FROM okc_bus_doc_types_b
1779: WHERE document_type = l_from_bus_doc_type;
1780:
1781:
1782: CURSOR attach_csr(l_from_bus_doc_type VARCHAR2, l_from_bus_doc_id NUMBER,

Line 1910: -- Get the doc_version_view name from okc_bus_doc_types_b

1906: END IF;
1907: IF (l_copy_all_docs_yn = 'Y') THEN -- Need to copy all seeded and custom categories.
1908:
1909: -- Fix for bug 6468721
1910: -- Get the doc_version_view name from okc_bus_doc_types_b
1911: -- to decide if l_version_query needs to be run
1912: IF NOT doc_version_view_name_csr%ISOPEN THEN
1913: OPEN doc_version_view_name_csr(p_from_bus_doc_type);
1914: FETCH doc_version_view_name_csr into l_doc_version_view_name;