APPS.OZF_REQUEST_STATUS_PVT dependencies on JTF_NOTES_VL
Line 294: from jtf_notes_vl
290: -- BUG 4460277 (-)
291:
292: cursor lc_get_notes(pc_entity_type varchar2, pc_entity_id number) is
293: select notes_detail 294: from jtf_notes_vl 295: where source_object_code = pc_entity_type
296: AND SOURCE_OBJECT_ID = pc_entity_id
297: AND NOTE_STATUS in ('E' , 'I') -- only publish notes and also Public
298: ORDER BY CREATION_DATE DESC;