APPS.PO_WF_REQ_NOTIFICATION dependencies on PO_DOCUMENT_TYPES_TL

Line 3011: ** po document types tl table.

3007: l_territory varchar2(240);
3008:
3009: /* Bug# 2616355: kagarwal
3010: ** Desc: We will get the document type display value from
3011: ** po document types tl table.
3012: */
3013:
3014: cursor c_lookup_value(p_doc_subtype varchar2, p_language varchar2) is
3015: select type_name

Line 3016: from po_document_types_tl tl, FND_LANGUAGES fl

3012: */
3013:
3014: cursor c_lookup_value(p_doc_subtype varchar2, p_language varchar2) is
3015: select type_name
3016: from po_document_types_tl tl, FND_LANGUAGES fl
3017: where fl.nls_language = p_language
3018: and tl.LANGUAGE = fl.language_code
3019: and tl.document_type_code = 'REQUISITION'
3020: and tl.document_subtype = p_doc_subtype;