3297: l_mipr_type_disp VARCHAR2(100);
3298:
3299: /* Bug# 2616355: kagarwal
3300: ** Desc: We will get the document type display value from
3301: ** po document types tl table.
3302: */
3303:
3304: cursor c_lookup_value(p_doc_subtype varchar2, p_language varchar2) is
3305: select type_name
3302: */
3303:
3304: cursor c_lookup_value(p_doc_subtype varchar2, p_language varchar2) is
3305: select type_name
3306: from po_document_types_tl tl, FND_LANGUAGES fl
3307: where fl.nls_language = p_language
3308: and tl.LANGUAGE = fl.language_code
3309: and tl.document_type_code = 'REQUISITION'
3310: and tl.document_subtype = p_doc_subtype;