APPS.CSL_DEBRIEF_PKG dependencies on CSL_CSF_DEBRIEF_HEADERS_INQ

Line 23: , CSL_CSF_DEBRIEF_HEADERS_INQ dbh

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
27: ORDER BY dbl.debrief_header_id;

Line 43: FROM CSL_CSF_DEBRIEF_HEADERS_INQ

39: AND clid$$cs = b_user_name;
40:
41: CURSOR c_debrief_no_lines( b_user_name VARCHAR2, b_tranid NUMBER) is
42: SELECT *
43: FROM CSL_CSF_DEBRIEF_HEADERS_INQ
44: WHERE tranid$$ = b_tranid
45: AND clid$$cs = b_user_name;
46:
47: /***

Line 74: FROM CSL_CSF_DEBRIEF_HEADERS_INQ

70: ********************************************************/
71:
72: CURSOR c_csf_debrief_headers (b_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE) is
73: SELECT *
74: FROM CSL_CSF_DEBRIEF_HEADERS_INQ
75: WHERE debrief_header_id = b_debrief_header_id;
76:
77: r_csf_debrief_headers c_csf_debrief_headers%ROWTYPE;
78:

Line 298: FROM CSL_CSF_DEBRIEF_HEADERS_INQ dbh

294: an record created on the backend for this header.
295: ***/
296: CURSOR c_debrief_assignment_id ( b_debrief_header_id NUMBER) is
297: SELECT task_assignment_id, seqno$$
298: FROM CSL_CSF_DEBRIEF_HEADERS_INQ dbh
299: WHERE debrief_header_id = b_debrief_header_id;
300: r_debrief_assignment_id c_debrief_assignment_id%ROWTYPE;
301:
302: l_return_status VARCHAR2(1);

Line 910: FROM CSL_CSF_DEBRIEF_HEADERS_INQ dbh

906: ***/
907:
908: CURSOR c_debrief_assignment_id ( b_debrief_header_id NUMBER) is
909: SELECT task_assignment_id, seqno$$
910: FROM CSL_CSF_DEBRIEF_HEADERS_INQ dbh
911: WHERE debrief_header_id = b_debrief_header_id;
912: r_debrief_assignment_id c_debrief_assignment_id%ROWTYPE;
913:
914: CURSOR c_csf_debrief_headers (

Line 916: SELECT * FROM CSL_CSF_DEBRIEF_HEADERS_INQ

912: r_debrief_assignment_id c_debrief_assignment_id%ROWTYPE;
913:
914: CURSOR c_csf_debrief_headers (
915: b_debrief_header_id CSF_DEBRIEF_HEADERS.DEBRIEF_HEADER_ID%TYPE) IS
916: SELECT * FROM CSL_CSF_DEBRIEF_HEADERS_INQ
917: WHERE debrief_header_id = b_debrief_header_id;
918: r_csf_debrief_headers c_csf_debrief_headers%ROWTYPE;
919:
920: l_deb_rec csf_debrief_pub.debrief_rec_type;