APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on CSF_M_NOTES_INQ

Line 28: FROM csf_m_notes_inq

24:
25: CURSOR c_debrief_notes(p_debrief_header_id number, b_user_name varchar2, b_tranid number)
26: IS
27: SELECT jtf_note_id, source_object_id
28: FROM csf_m_notes_inq
29: WHERE tranid$$ = b_tranid
30: AND clid$$cs = b_user_name
31: AND source_object_code = 'SD'
32: AND source_object_id = p_debrief_header_id

Line 609: UPDATE csf_m_notes_inq

605: OPEN c_debrief(r_debrief_headers.task_assignment_id);
606: FETCH c_debrief INTO l_debrief_header_id;
607: IF c_debrief%FOUND THEN
608: FOR r_debrief_notes IN c_debrief_notes(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP
609: UPDATE csf_m_notes_inq
610: SET source_object_id = l_debrief_header_id
611: WHERE CURRENT OF c_debrief_notes;
612: END LOOP;
613:

Line 653: UPDATE csf_m_notes_inq

649: OPEN c_debrief(r_debrief_headers.task_assignment_id);
650: FETCH c_debrief INTO l_debrief_header_id;
651: IF c_debrief%FOUND THEN
652: FOR r_debrief_notes IN c_debrief_notes(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP
653: UPDATE csf_m_notes_inq
654: SET source_object_id = l_debrief_header_id
655: WHERE CURRENT OF c_debrief_notes;
656: END LOOP;
657: FOR r_debrief_signature IN c_debrief_signature(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP