APPS.CSL_JTF_TASK_ASS_ACC_PKG dependencies on CSL_SERVICE_HISTORY

Line 842: AND NOT EXISTS (SELECT 'x' FROM CSL_SERVICE_HISTORY hist

838: OR NVL(jta_jts.cancelled_flag,'N') = 'Y'
839: OR NVL(jta_jts.closed_flag,'N') = 'Y'
840: OR NVL(jta_jts.completed_flag,'N') = 'Y'
841: OR NVL(jta_jts.rejected_flag, 'N') = 'Y')
842: AND NOT EXISTS (SELECT 'x' FROM CSL_SERVICE_HISTORY hist
843: WHERE hist.history_incident_id = jt.source_object_id
844: AND jt.source_object_type_code = 'SR'
845: AND hist.resource_id = acc.resource_id);
846: