DBA Data[Home] [Help]

APPS.CSM_SR_CONTACT_EVENT_PKG dependencies on CSM_INCIDENTS_ALL_ACC

Line 109: csm_incidents_all_acc acc

105: IS
106: SELECT acc.incident_id,
107: acc.user_id
108: FROM cs_hz_sr_contact_points srcp,
109: csm_incidents_all_acc acc
110: WHERE srcp.sr_contact_point_id = p_sr_contact_point_id
111: AND acc.incident_id = srcp.incident_id
112: AND NOT EXISTS
113: (SELECT 1

Line 185: csm_incidents_all_acc acc

181: IS
182: SELECT acc.incident_id,
183: acc.user_id
184: FROM cs_hz_sr_contact_points srcp,
185: csm_incidents_all_acc acc
186: WHERE srcp.sr_contact_point_id = p_sr_contact_point_id
187: AND acc.incident_id = srcp.incident_id
188: AND EXISTS
189: (SELECT 1