DBA Data[Home] [Help]

APPS.CSM_DEBRIEF_HEADERS_PKG dependencies on CSM_DEBRIEF_HEADERS_INQ

Line 21: FROM csm_debrief_headers_inq

17: g_debug_level NUMBER; -- debug level
18:
19: CURSOR c_debrief_headers( b_user_name VARCHAR2, b_tranid NUMBER) is
20: SELECT *
21: FROM csm_debrief_headers_inq
22: WHERE tranid$$ = b_tranid
23: AND clid$$cs = b_user_name;
24:
25: CURSOR c_debrief_notes(p_debrief_header_id number, b_user_name varchar2, b_tranid number)

Line 717: csm_debrief_headers_inq a

713: l_sequence in number)
714: IS
715: SELECT b.last_updated_by
716: FROM csf_debrief_headers b,
717: csm_debrief_headers_inq a
718: WHERE a.clid$$cs = l_user_name
719: AND tranid$$ = l_tran_id
720: AND seqno$$ = l_sequence
721: AND a.debrief_header_id = b.debrief_header_id ;