DBA Data[Home] [Help]

APPS.OKC_CONTRACT_DOCS_GRP dependencies on OKC_BUS_DOC_TYPES_B

Line 1780: FROM okc_bus_doc_types_b

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

Line 1921: -- Get the doc_version_view name from okc_bus_doc_types_b

1917: END IF;
1918: IF (l_copy_all_docs_yn = 'Y') THEN -- Need to copy all seeded and custom categories.
1919:
1920: -- Fix for bug 6468721
1921: -- Get the doc_version_view name from okc_bus_doc_types_b
1922: -- to decide if l_version_query needs to be run
1923: IF NOT doc_version_view_name_csr%ISOPEN THEN
1924: OPEN doc_version_view_name_csr(p_from_bus_doc_type);
1925: FETCH doc_version_view_name_csr into l_doc_version_view_name;