DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on FND_LANGUAGES

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;

Line 3025: from FND_LOOKUP_VALUES flv, FND_LANGUAGES fl

3021:
3022: /*
3023: cursor c_lookup_value(p_doc_subtype varchar2, p_language varchar2) is
3024: select MEANING
3025: from FND_LOOKUP_VALUES flv, FND_LANGUAGES fl
3026: where
3027: fl.nls_language = p_language
3028: and flv.LANGUAGE = fl.language_code
3029: and flv.lookup_type='REQUISITION TYPE'