APPS.CSM_REQUIREMENTS_PKG dependencies on CSM_REQ_HEADERS_INQ

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 79: FROM CSM_REQ_HEADERS_INQ

75:
76: -- Cursor to retrieve requirement header from the inqueue
77: CURSOR c_get_requirement_from_inq ( b_user_name VARCHAR2, b_tranid NUMBER, b_requirement_header_id NUMBER) is
78: SELECT *
79: FROM CSM_REQ_HEADERS_INQ
80: WHERE tranid$$ = b_tranid
81: AND clid$$cs = b_user_name
82: AND requirement_header_id = b_requirement_header_id;
83:

Line 286: FROM CSM_REQ_HEADERS_INQ h

282: This one is to be executed after all requirement lines with headers have been deleted from the inqueue.
283: ***/
284: CURSOR c_get_req_headers_processed ( b_user_name VARCHAR2, b_tranid NUMBER) is
285: SELECT *
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

Line 298: FROM CSM_REQ_HEADERS_INQ h

294: );
295:
296: CURSOR c_get_req_headers_deferred ( b_user_name VARCHAR2, b_tranid NUMBER) is
297: SELECT *
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