DBA Data[Home] [Help]

APPS.CSM_UNDO_PKG dependencies on CSM_REQ_HEADERS_INQ

Line 144: CSM_REQ_HEADERS_INQ inq

140: CURSOR c_get_req_header(c_task_assg_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
141: IS
142: SELECT ACCESS_ID,INQ.REQUIREMENT_HEADER_ID,INQ.TRANID$$,INQ.SEQNO$$
143: FROM CSM_REQ_HEADERS_ACC acc,
144: CSM_REQ_HEADERS_INQ inq
145: WHERE acc.USER_ID(+) = c_user_id
146: AND inq.TASK_ASSIGNMENT_ID = c_task_assg_id
147: AND inq.REQUIREMENT_HEADER_ID = acc.REQUIREMENT_HEADER_ID(+)
148: AND inq.CLID$$CS = c_user_name;