APPS.CSL_REQUIREMENTS_PKG dependencies on CSL_CSP_REQUIREMENT_HDR_INQ

Line 19: FROM CSL_CSP_REQUIREMENT_LNS_inq reql, CSL_CSP_REQUIREMENT_HDR_inq reqh

15: have a requirement header record in the requirement header inqueue.
16: ***/
17: CURSOR c_requirements ( b_user_name VARCHAR2, b_tranid NUMBER) is
18: SELECT reql.*
19: FROM CSL_CSP_REQUIREMENT_LNS_inq reql, CSL_CSP_REQUIREMENT_HDR_inq reqh
20: WHERE reql.tranid$$ = b_tranid
21: AND reql.clid$$cs = b_user_name
22: AND reql.requirement_header_id = reqh.requirement_header_id;
23:

Line 66: FROM CSL_CSP_REQUIREMENT_HDR_inq

62:
63: -- Cursor to retrieve requirement header from the inqueue
64: CURSOR c_get_requirement_from_inq ( b_user_name VARCHAR2, b_tranid NUMBER, b_requirement_header_id NUMBER) is
65: SELECT *
66: FROM CSL_CSP_REQUIREMENT_HDR_inq
67: WHERE tranid$$ = b_tranid
68: AND clid$$cs = b_user_name
69: AND requirement_header_id = b_requirement_header_id;
70:

Line 399: FROM CSL_CSP_REQUIREMENT_HDR_inq

395: This one is to be executed after all requirement lines with headers have been deleted from the inqueue.
396: ***/
397: CURSOR c_get_req_headers_from_inq ( b_user_name VARCHAR2, b_tranid NUMBER) is
398: SELECT *
399: FROM CSL_CSP_REQUIREMENT_HDR_inq
400: WHERE tranid$$ = b_tranid
401: AND clid$$cs = b_user_name;
402:
403: BEGIN