APPS.CSM_PARTY_SITE_EVENT_PKG dependencies on CSM_INCIDENTS_ALL_ACC
Line 119: FROM CSM_INCIDENTS_ALL_ACC acc,
115: FROM hz_party_sites ps
116: WHERE party_site_id = p_party_site_id
117: AND NOT EXISTS
118: ( SELECT 1 119: FROM CSM_INCIDENTS_ALL_ACC acc, 120: CS_INCIDENTS_ALL_B B
121: Where B.Incident_Id = Acc.Incident_Id
122: AND B.INCIDENT_LOCATION_TYPE ='HZ_PARTY_SITE'
123: AND ACC.USER_ID = C_USER_ID