DBA Data[Home] [Help]

APPS.CSM_USER_EVENT_PKG dependencies on CS_INCIDENT_STATUSES_B

Line 231: cs_incident_statuses_b ists

227: AND jt.source_object_type_code ='SR'
228: AND EXISTS
229: (SELECT inc.incident_id
230: FROM cs_incidents_all_b inc,
231: cs_incident_statuses_b ists
232: WHERE inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
233: AND NVL(ists.CLOSE_FLAG,'N')= 'N'
234: AND inc.incident_id = jt.source_object_id
235: );

Line 272: cs_incident_statuses_b ists

268: CURSOR l_incident_csr (b_grp_id NUMBER,b_user_id NUMBER)
269: IS
270: SELECT incident_id
271: FROM cs_incidents_all_b inc,
272: cs_incident_statuses_b ists
273: WHERE (
274: inc.owner_group_id = b_grp_id
275: OR
276: csm_util_pkg.get_owner(inc.created_by)=b_user_id

Line 362: cs_incident_statuses_b ists

358: AND jt.source_object_type_code ='SR'
359: AND EXISTS
360: (SELECT 'X'
361: FROM cs_incidents_all_b inc,
362: cs_incident_statuses_b ists
363: WHERE inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
364: AND NVL(ists.CLOSE_FLAG,'N')= 'N'
365: AND inc.incident_id = jt.source_object_id
366: );