DBA Data[Home] [Help]

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