DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on PO_DOCUMENT_TYPES

Line 1762: from po_document_types_tl tl, FND_LANGUAGES fl

1758:
1759: cursor c_lookup_value_user(p_doc_type varchar2, p_doc_subtype varchar2,
1760: p_language varchar2) is
1761: select type_name
1762: from po_document_types_tl tl, FND_LANGUAGES fl
1763: where fl.nls_language = p_language
1764: and tl.LANGUAGE = fl.language_code
1765: and tl.document_type_code = p_doc_type
1766: and tl.document_subtype = p_doc_subtype;

Line 1770: from po_document_types

1766: and tl.document_subtype = p_doc_subtype;
1767:
1768: cursor c_lookup_value_doc(p_doc_type varchar2, p_doc_subtype varchar2) is
1769: select type_name
1770: from po_document_types
1771: where document_type_code = p_doc_type
1772: and document_subtype = p_doc_subtype;
1773:
1774: l_document_id PO_HEADERS_ALL.po_header_id%TYPE; --