APPS.CSL_DEBRIEF_PKG dependencies on CSL_CSF_DEBRIEF_LINES_INQ

Line 22: FROM CSL_CSF_DEBRIEF_LINES_INQ dbl

18: have a debrief header record in the debrief header inqueue.
19: ***/
20: CURSOR c_debrief ( b_user_name VARCHAR2, b_tranid NUMBER) is
21: SELECT dbl.*
22: FROM CSL_CSF_DEBRIEF_LINES_INQ dbl
23: , CSL_CSF_DEBRIEF_HEADERS_INQ dbh
24: WHERE dbl.debrief_header_id = dbh.debrief_header_id
25: AND dbl.tranid$$ = b_tranid
26: AND dbl.clid$$cs = b_user_name

Line 37: FROM CSL_CSF_DEBRIEF_LINES_INQ

33: The debrief lines without header remain then.
34: ***/
35: CURSOR c_debrief_no_headers( b_user_name VARCHAR2, b_tranid NUMBER) is
36: SELECT *
37: FROM CSL_CSF_DEBRIEF_LINES_INQ
38: WHERE tranid$$ = b_tranid
39: AND clid$$cs = b_user_name;
40:
41: CURSOR c_debrief_no_lines( b_user_name VARCHAR2, b_tranid NUMBER) is