DBA Data[Home] [Help]

APPS.DPP_REQUEST_STATUS_PVT dependencies on JTF_NOTES_VL

Line 228: from jtf_notes_vl

224: and lkup.lookup_type = 'DPP_TRANSACTION_STATUSES';
225:
226: cursor lc_get_notes(pc_entity_type varchar2, pc_transaction_header_id number) is
227: select notes_detail
228: from jtf_notes_vl
229: where source_object_code = pc_entity_type
230: AND SOURCE_OBJECT_ID = pc_transaction_header_id
231: AND NOTE_STATUS in ('E' , 'I') -- only publish notes and also Public
232: ORDER BY CREATION_DATE DESC;