APPS.OKC_TERMS_QA_PVT dependencies on OKC_BUS_DOC_TYPES_TL

Line 2704: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;

2700: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2701: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2702: l_perform_tmpl_qa VARCHAR2(1);
2703: l_tmpl_usg_exists_flag varchar2(1):=OKC_API.G_MISS_CHAR;
2704: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
2705:
2706:
2707: CURSOR l_get_template_crs IS
2708: SELECT status_code,end_date,template_name

Line 2728: FROM okc_bus_doc_types_tl

2724: AND DOCUMENT_TYPE = p_doc_type;
2725: --Bug 4126819 Added cursor to get the document type
2726: CURSOR l_get_doc_type_name IS
2727: SELECT name
2728: FROM okc_bus_doc_types_tl
2729: WHERE document_type = p_doc_type
2730: AND LANGUAGE = userenv('LANG');
2731:
2732: BEGIN