APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSM_SERVICE_HISTORY_ACC
Line 53: FROM csm_service_history_acc hist,
49: OR jts.completed_flag = 'Y' OR jts.rejected_flag = 'Y'
50: OR jts_jta.cancelled_flag = 'Y' OR jts_jta.closed_flag = 'Y'
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