APPS.OKC_TERMS_COPY_PVT dependencies on OKC_BUS_DOC_TYPES_V

Line 2048: l_doc_type_name OKC_BUS_DOC_TYPES_V.NAME%TYPE;

2044:
2045: l_api_version CONSTANT NUMBER := 1;
2046: l_api_name CONSTANT VARCHAR2(30) := 'copy_tc';
2047: l_dummy_var VARCHAR2(1) :='?';
2048: l_doc_type_name OKC_BUS_DOC_TYPES_V.NAME%TYPE;
2049: l_article_effective_date DATE;
2050: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2051: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;
2052: l_document_id NUMBER;

Line 2072: SELECT name FROM OKC_BUS_DOC_TYPES_V

2068: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
2069: WHERE template_id=p_source_doc_id;
2070:
2071: CURSOR l_get_doc_type_name_csr IS
2072: SELECT name FROM OKC_BUS_DOC_TYPES_V
2073: WHERE document_type = p_target_doc_type;
2074:
2075: CURSOR l_check_tmp_usage_csr IS
2076: SELECT '!' FROM OKC_TEMPLATE_USAGES