APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on CSF_M_LOBS_INQ

Line 46: FROM csf_m_lobs_inq

42: CURSOR c_debrief_signature(p_debrief_header_id IN NUMBER, b_user_name IN VARCHAR2,
43: b_tranid IN NUMBER)
44: IS
45: SELECT file_id, pk1_value
46: FROM csf_m_lobs_inq
47: WHERE tranid$$ = b_tranid
48: AND clid$$cs = b_user_name
49: AND entity_name = 'CSF_DEBRIEF_HEADERS'
50: AND to_number(pk1_value) = p_debrief_header_id

Line 637: UPDATE csf_m_lobs_inq

633: WHERE CURRENT OF c_debrief_notes;
634: END LOOP;
635:
636: FOR r_debrief_signature IN c_debrief_signature(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP
637: UPDATE csf_m_lobs_inq
638: SET pk1_value = l_debrief_header_id
639: WHERE CURRENT OF c_debrief_signature;
640: END LOOP;
641:

Line 680: UPDATE csf_m_lobs_inq

676: SET source_object_id = l_debrief_header_id
677: WHERE CURRENT OF c_debrief_notes;
678: END LOOP;
679: FOR r_debrief_signature IN c_debrief_signature(r_debrief_headers.debrief_header_id, r_debrief_headers.clid$$cs, r_debrief_headers.tranid$$) LOOP
680: UPDATE csf_m_lobs_inq
681: SET pk1_value = l_debrief_header_id
682: WHERE CURRENT OF c_debrief_signature;
683: END LOOP;
684: