APPS.OKC_TERMS_COPY_PVT dependencies on OKC_BUS_DOC_TYPES_V

Line 2619: l_doc_type_name OKC_BUS_DOC_TYPES_V.NAME%TYPE;

2615:
2616: l_api_version CONSTANT NUMBER := 1;
2617: l_api_name CONSTANT VARCHAR2(30) := 'copy_tc';
2618: l_dummy_var VARCHAR2(1) :='?';
2619: l_doc_type_name OKC_BUS_DOC_TYPES_V.NAME%TYPE;
2620: l_article_effective_date DATE;
2621: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2622: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;
2623: l_document_id NUMBER;

Line 2643: SELECT name FROM OKC_BUS_DOC_TYPES_V

2639: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
2640: WHERE template_id=p_source_doc_id;
2641:
2642: CURSOR l_get_doc_type_name_csr IS
2643: SELECT name FROM OKC_BUS_DOC_TYPES_V
2644: WHERE document_type = p_target_doc_type;
2645:
2646: CURSOR l_check_tmp_usage_csr IS
2647: SELECT '!' FROM OKC_TEMPLATE_USAGES