DBA Data[Home] [Help]

APPS.CSM_SR_EVENT_PKG dependencies on CS_INCIDENT_STATUSES_B

Line 51: cs_incident_statuses_b ists

47: acc.user_id,
48: acc.counter
49: FROM csm_incidents_all_acc acc,
50: cs_incidents_all_b inc,
51: cs_incident_statuses_b ists
52: WHERE inc.incident_id = acc.incident_id
53: AND decode(CSM_UTIL_PKG.get_group_owner(inc.owner_group_id),
54: -1,
55: CSM_UTIL_PKG.get_owner(inc.created_by),

Line 1544: cs_incident_statuses_b ists,

1540: CURSOR l_is_sr_open_csr(c_task_id jtf_tasks_b.task_id%TYPE)
1541: IS
1542: SELECT inc.incident_id
1543: FROM cs_incidents_all_b inc,
1544: cs_incident_statuses_b ists,
1545: jtf_tasks_b tsk
1546: WHERE inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
1547: AND ists.CLOSE_FLAG = 'Y'
1548: AND tsk.task_id = c_task_id