DBA Data[Home] [Help]

APPS.CS_SR_CTX_PKG dependencies on JTF_NOTES_B

Line 32: from jtf_notes_tl tl, jtf_notes_b b

28:
29: CURSOR GET_SR_NOTS (c_obj_id NUMBER, c_lang VARCHAR2) IS
30: select tl.notes, b.note_status, b.created_by
31: ,tl.notes_detail
32: from jtf_notes_tl tl, jtf_notes_b b
33: where tl.jtf_note_id = b.jtf_note_id
34: and b.source_object_code = 'SR'
35: and b.source_object_id = c_obj_id
36: and b.note_status in ('E', 'I')