APPS.CSM_NOTES_PKG dependencies on JTF_NOTES_B

Line 116: CURSOR l_server_last_update_date_csr(p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE)

112: l_msg_count number;
113: l_msg_data varchar2(1024);
114:
115: l_server_last_update_date date;
116: CURSOR l_server_last_update_date_csr(p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE)
117: IS
118: select last_update_date from jtf_notes_b
119: where jtf_note_id = p_jtf_note_id;
120:

Line 118: select last_update_date from jtf_notes_b

114:
115: l_server_last_update_date date;
116: CURSOR l_server_last_update_date_csr(p_jtf_note_id jtf_notes_b.jtf_note_id%TYPE)
117: IS
118: select last_update_date from jtf_notes_b
119: where jtf_note_id = p_jtf_note_id;
120:
121: BEGIN
122: CSM_UTIL_PKG.log( 'Entering ' || g_object_name || '.APPLY_UPDATE:'

Line 129: --from jtf_notes_b

125: FND_LOG.LEVEL_PROCEDURE );
126: --get the last update date of the note
127:
128: --select last_update_date into l_server_last_update_date
129: --from jtf_notes_b
130: --where jtf_note_id = p_record.jtf_note_id;
131:
132: OPEN l_server_last_update_date_csr(p_record.jtf_note_id);
133: FETCH l_server_last_update_date_csr INTO l_server_last_update_date;