DBA Data[Home] [Help]

APPS.PV_BENFT_STATUS_CHANGE dependencies on JTF_NOTES_VL

Line 1184: from jtf_notes_vl

1180:
1181:
1182: cursor lc_get_notes(pc_entity_type varchar2, pc_entity_id number) is
1183: select notes, NOTES_DETAIL
1184: from jtf_notes_vl
1185: where source_object_code = pc_entity_type
1186: AND SOURCE_OBJECT_ID = pc_entity_id
1187: AND NOTE_STATUS = 'E' -- only publish notes
1188: ORDER BY CREATION_DATE DESC;