APPS.CSM_REQUIREMENTS_PKG dependencies on CSM_REQ_LINES_INQ

Line 21: FROM CSM_REQ_LINES_INQ l

17: g_pub_name2 CONSTANT VARCHAR2(30) := 'CSM_REQ_HEADERS'; -- publication item name
18:
19: CURSOR c_requirement_lines ( b_user_name VARCHAR2, b_tranid NUMBER, b_req_hdr_id NUMBER) is
20: SELECT *
21: FROM CSM_REQ_LINES_INQ l
22: WHERE l.tranid$$ = b_tranid
23: AND l.clid$$cs = b_user_name
24: AND l.requirement_header_id = b_req_hdr_id;
25:

Line 28: FROM CSM_REQ_LINES_INQ l

24: AND l.requirement_header_id = b_req_hdr_id;
25:
26: CURSOR c_headers_from_apps ( b_user_name VARCHAR2, b_tranid NUMBER) is
27: SELECT distinct l.requirement_header_id
28: FROM CSM_REQ_LINES_INQ l
29: WHERE l.tranid$$ = b_tranid
30: AND l.clid$$cs = b_user_name
31: AND EXISTS
32: (SELECT 1

Line 39: FROM CSM_REQ_LINES_INQ reql, CSM_REQ_HEADERS_INQ reqh

35: );
36:
37: CURSOR c_headers_from_inq ( b_user_name VARCHAR2, b_tranid NUMBER) is
38: SELECT distinct reqh.requirement_header_id
39: FROM CSM_REQ_LINES_INQ reql, CSM_REQ_HEADERS_INQ reqh
40: WHERE reql.tranid$$ = reqh.tranid$$
41: AND reql.clid$$cs = reqh.clid$$cs
42: AND reql.tranid$$ = b_tranid
43: AND reql.clid$$cs = b_user_name

Line 290: FROM csm_req_lines_inq l

286: FROM CSM_REQ_HEADERS_INQ h
287: WHERE h.tranid$$ = b_tranid
288: AND h.clid$$cs = b_user_name
289: AND NOT EXISTS (SELECT 1
290: FROM csm_req_lines_inq l
291: WHERE l.tranid$$ = b_tranid
292: AND l.clid$$cs = b_user_name
293: AND l.requirement_header_id = h.requirement_header_id
294: );

Line 302: FROM csm_req_lines_inq l

298: FROM CSM_REQ_HEADERS_INQ h
299: WHERE h.tranid$$ = b_tranid
300: AND h.clid$$cs = b_user_name
301: AND EXISTS (SELECT 1
302: FROM csm_req_lines_inq l
303: WHERE l.tranid$$ = b_tranid
304: AND l.clid$$cs = b_user_name
305: AND l.requirement_header_id = h.requirement_header_id
306: )