APPS.CSM_CONTRACT_EVENT_PKG dependencies on JTF_NOTES_B

Line 31: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';

27: g_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC_S';
28:
29: -- CSF_M_NOTES
30: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';
31: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
32: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';
33: g_notes_pk1_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
34: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
35: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');

Line 580: FROM jtf_notes_b notes, csm_notes_acc acc

576: CURSOR l_oks_notes_csr (p_sourceobjectcode VARCHAR2,
577: p_sourceobjectid NUMBER,
578: p_user_id NUMBER) IS
579: SELECT acc.jtf_note_id, acc.user_id
580: FROM jtf_notes_b notes, csm_notes_acc acc
581: WHERE notes.source_object_code = p_sourceobjectcode
582: AND notes.source_object_id = p_sourceobjectid
583: AND notes.jtf_note_id = acc.jtf_note_id
584: AND acc.user_id = p_user_id;

Line 632: FROM jtf_notes_b

628:
629: CURSOR l_oks_notes_csr (p_sourceobjectcode VARCHAR2,
630: p_sourceobjectid NUMBER) IS
631: SELECT jtf_note_id
632: FROM jtf_notes_b
633: WHERE source_object_code = p_sourceobjectcode
634: AND source_object_id = p_sourceobjectid;
635:
636: BEGIN