DBA Data[Home] [Help]

APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on CSM_TASK_ASSIGNMENTS_ACC

Line 590: FROM CSM_TASK_ASSIGNMENTS_ACC ACC,

586: FROM CSM_SERVICE_HISTORY_ACC
587: WHERE INCIDENT_ID = b_incident_id
588: AND USER_ID = b_user_id
589: AND NOT EXISTS (SELECT 'X'
590: FROM CSM_TASK_ASSIGNMENTS_ACC ACC,
591: JTF_TASK_ASSIGNMENTS ASG,
592: JTF_TASKS_B TASK
593: WHERE ACC.TASK_ASSIGNMENT_ID = ASG.TASK_ASSIGNMENT_ID
594: AND ASG.TASK_ID = TASK.TASK_ID