DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on CSM_REQ_LINES_ACC

Line 289: FROM CSM_REQ_LINES_ACC acc,

285:
286: CURSOR c_get_req_line(c_req_header_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
287: IS
288: SELECT ACCESS_ID,INQ.REQUIREMENT_LINE_ID,INQ.TRANID$$,INQ.SEQNO$$
289: FROM CSM_REQ_LINES_ACC acc,
290: CSM_REQ_LINES_INQ inq
291: WHERE acc.USER_ID (+) = c_user_id
292: AND inq.REQUIREMENT_HEADER_ID = c_req_header_id
293: AND inq.REQUIREMENT_LINE_ID = acc.REQUIREMENT_LINE_ID (+)