APPS.CSM_CONTRACT_EVENT_PKG dependencies on JTF_NOTES_B

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

36: g_sequence_name4 CONSTANT VARCHAR2(30) := 'CSM_COV_ACTION_TIMES_ACC_S';
37:
38: -- CSF_M_NOTES
39: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';
40: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';
41: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC_S';
42: g_notes_pk1_name CONSTANT VARCHAR2(30) := 'JTF_NOTE_ID';
43: g_notes_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
44: CSM_ACC_PKG.t_publication_item_list('CSF_M_NOTES');

Line 744: FROM jtf_notes_b notes, csm_notes_acc acc

740: CURSOR l_oks_notes_csr (p_sourceobjectcode VARCHAR2,
741: p_sourceobjectid NUMBER,
742: p_user_id NUMBER) IS
743: SELECT acc.jtf_note_id, acc.user_id
744: FROM jtf_notes_b notes, csm_notes_acc acc
745: WHERE notes.source_object_code = p_sourceobjectcode
746: AND notes.source_object_id = p_sourceobjectid
747: AND notes.jtf_note_id = acc.jtf_note_id
748: AND acc.user_id = p_user_id;

Line 796: FROM jtf_notes_b

792:
793: CURSOR l_oks_notes_csr (p_sourceobjectcode VARCHAR2,
794: p_sourceobjectid NUMBER) IS
795: SELECT jtf_note_id
796: FROM jtf_notes_b
797: WHERE source_object_code = p_sourceobjectcode
798: AND source_object_id = p_sourceobjectid;
799:
800: BEGIN