DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on CSM_NOTES_ACC

Line 299: FROM CSM_NOTES_ACC acc,

295:
296: 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)
297: IS
298: SELECT ACCESS_ID,INQ.JTF_NOTE_ID,INQ.TRANID$$,INQ.SEQNO$$, INQ.DMLTYPE$$
299: FROM CSM_NOTES_ACC acc,
300: CSF_M_NOTES_INQ inq
301: WHERE acc.USER_ID (+) = c_user_id
302: AND inq.JTF_NOTE_ID = acc.JTF_NOTE_ID (+)
303: AND inq.CLID$$CS = c_user_name