APPS.CSM_REQUIREMENTS_PKG dependencies on CSM_REQ_LINES_INQ

Line 27: FROM CSM_REQ_LINES_INQ l

23: The requirement lines without header remain then.
24: ***/
25: CURSOR c_requirements_no_headers ( b_user_name VARCHAR2, b_tranid NUMBER) is
26: SELECT *
27: FROM CSM_REQ_LINES_INQ l
28: WHERE l.tranid$$ = b_tranid
29: AND l.clid$$cs = b_user_name
30: AND EXISTS
31: (SELECT 1

Line 43: FROM CSM_REQ_LINES_INQ reql, CSM_REQ_HEADERS_INQ reqh

39: ***/
40:
41: CURSOR c_requirements ( b_user_name VARCHAR2, b_tranid NUMBER) is
42: SELECT reql.*
43: FROM CSM_REQ_LINES_INQ reql, CSM_REQ_HEADERS_INQ reqh
44: WHERE reql.tranid$$ = reqh.tranid$$
45: AND reql.clid$$cs = reqh.clid$$cs
46: AND reql.tranid$$ = b_tranid
47: AND reql.clid$$cs = b_user_name

Line 426: FROM csm_req_lines_inq l

422: FROM CSM_REQ_HEADERS_INQ h
423: WHERE h.tranid$$ = b_tranid
424: AND h.clid$$cs = b_user_name
425: AND NOT EXISTS (SELECT 1
426: FROM csm_req_lines_inq l
427: WHERE l.tranid$$ = b_tranid
428: AND l.clid$$cs = b_user_name
429: AND l.requirement_header_id = h.requirement_header_id
430: );