DBA Data[Home] [Help]

APPS.CSM_UNDO_PKG dependencies on CSM_DEBRIEF_HEADERS_INQ

Line 103: CSM_DEBRIEF_HEADERS_INQ inq

99: CURSOR c_get_debrief_header(c_task_assg_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
100: IS
101: SELECT ACCESS_ID,INQ.DEBRIEF_HEADER_ID,INQ.TRANID$$,INQ.SEQNO$$
102: FROM CSM_DEBRIEF_HEADERS_ACC acc,
103: CSM_DEBRIEF_HEADERS_INQ inq
104: WHERE acc.USER_ID(+) = c_user_id
105: AND inq.TASK_ASSIGNMENT_ID = c_task_assg_id
106: AND inq.DEBRIEF_HEADER_ID = acc.DEBRIEF_HEADER_ID(+)
107: AND inq.CLID$$CS = c_user_name;