APPS.CSM_CONTRACT_EVENT_PKG dependencies on CSM_NOTES_ACC

Line 39: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';

35: g_pk3_name4 CONSTANT VARCHAR2(30) := 'ACTION_TYPE_CODE';
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 :=

Line 41: g_notes_seq_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_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');
45:

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;