DBA Data[Home] [Help]

APPS.DPP_REQUEST_STATUS_PVT dependencies on JTF_NOTES_VL

Line 226: from jtf_notes_vl

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