DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on FND_LANGUAGES

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 1860: from fnd_new_messages fm,fnd_languages fl

1856: avalue => l_doc_disp);
1857: BEGIN
1858: select message_text
1859: into l_msg_text
1860: from fnd_new_messages fm,fnd_languages fl
1861: where fm.message_name = 'PO_WF_NOTIF_REQUIRES_APPROVAL'
1862: and fm.language_code = fl.language_code
1863: and fl.nls_language = l_language
1864: and fm.application_id = 201; -- Include application_id to better use PK index