DBA Data[Home] [Help]

APPS.CSM_UNDO_PKG dependencies on CSM_NOTES_ACC

Line 163: FROM CSM_NOTES_ACC acc,

159:
160: CURSOR c_get_notes(c_task_id NUMBER,c_incident_id NUMBER,c_debrief_header_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
161: IS
162: SELECT ACCESS_ID,INQ.JTF_NOTE_ID,INQ.TRANID$$,INQ.SEQNO$$, INQ.DMLTYPE$$
163: FROM CSM_NOTES_ACC acc,
164: CSF_M_NOTES_INQ inq
165: WHERE acc.USER_ID (+) = c_user_id
166: AND inq.JTF_NOTE_ID = acc.JTF_NOTE_ID (+)
167: AND inq.CLID$$CS = c_user_name