26: g_pk3_name3 CONSTANT VARCHAR2(30) := 'TXN_BILLING_TYPE_ID';
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 :=
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');
36:
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;