APPS.OKC_TERMS_QA_PVT dependencies on OKC_BUS_DOC_TYPES_TL

Line 2738: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;

2734: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2735: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2736: l_perform_tmpl_qa VARCHAR2(1);
2737: l_tmpl_usg_exists_flag varchar2(1):=OKC_API.G_MISS_CHAR;
2738: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
2739:
2740:
2741: CURSOR l_get_template_crs IS
2742: SELECT status_code,end_date,template_name

Line 2762: FROM okc_bus_doc_types_tl

2758: AND DOCUMENT_TYPE = p_doc_type;
2759: --Bug 4126819 Added cursor to get the document type
2760: CURSOR l_get_doc_type_name IS
2761: SELECT name
2762: FROM okc_bus_doc_types_tl
2763: WHERE document_type = p_doc_type
2764: AND LANGUAGE = userenv('LANG');
2765:
2766: BEGIN