DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on PO_DOCUMENT_TYPES

Line 2600: from po_document_types_tl tl, FND_LANGUAGES fl

2596:
2597: cursor c_lookup_value_user(p_doc_type varchar2, p_doc_subtype varchar2,
2598: p_language varchar2) is
2599: select type_name
2600: from po_document_types_tl tl, FND_LANGUAGES fl
2601: where fl.nls_language = p_language
2602: and tl.LANGUAGE = fl.language_code
2603: and tl.document_type_code = p_doc_type
2604: and tl.document_subtype = p_doc_subtype;

Line 2608: from po_document_types

2604: and tl.document_subtype = p_doc_subtype;
2605:
2606: cursor c_lookup_value_doc(p_doc_type varchar2, p_doc_subtype varchar2) is
2607: select type_name
2608: from po_document_types
2609: where document_type_code = p_doc_type
2610: and document_subtype = p_doc_subtype;
2611:
2612: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --