DBA Data[Home] [Help]

APPS.CSM_TASK_ASSIGNMENTS_PKG dependencies on JTF_TASKS_B

Line 225: JTF_TASKS_B b,

221: CURSOR c_get_incident(c_task_id NUMBER,c_user_id NUMBER,c_user_name VARCHAR2)
222: IS
223: SELECT ACCESS_ID,INQ.INCIDENT_ID,INQ.TRANID$$,INQ.SEQNO$$
224: FROM CSM_INCIDENTS_ALL_ACC acc,
225: JTF_TASKS_B b,
226: CSM_INCIDENTS_ALL_INQ inq
227: WHERE acc.USER_ID = c_user_id
228: AND b.TASK_ID = c_task_id
229: AND b.SOURCE_OBJECT_ID = acc.INCIDENT_ID