APPS.CSL_REQUIREMENTS_PKG dependencies on CSL_CSP_REQUIREMENT_LNS_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 32: FROM CSL_CSP_REQUIREMENT_LNS_inq

28: The requirement lines without header remain then.
29: ***/
30: CURSOR c_requirements_no_headers ( b_user_name VARCHAR2, b_tranid NUMBER) is
31: SELECT *
32: FROM CSL_CSP_REQUIREMENT_LNS_inq
33: WHERE tranid$$ = b_tranid
34: AND clid$$cs = b_user_name;
35:
36: /***