DBA Data[Home] [Help]

APPS.CSM_PARTY_SITE_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 120: CS_INCIDENTS_ALL_B B

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
124: AND ps.party_site_id = b.incident_location_id);