APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CS_INCIDENT_STATUSES_B

Line 55: cs_incident_statuses_b ists

51: OR jts_jta.completed_flag = 'Y' OR jts_jta.rejected_flag = 'Y')
52: AND NOT EXISTS (SELECT 'x'
53: FROM csm_service_history_acc hist,
54: cs_incidents_all_b cia,
55: cs_incident_statuses_b ists
56: WHERE hist.user_id = acc.user_id
57: AND hist.history_incident_id = jt.source_object_id
58: AND jt.source_object_type_code = 'SR'
59: AND hist.incident_id = cia.incident_id