DBA Data[Home] [Help]

APPS.CS_SR_UTIL_PKG dependencies on CS_INCIDENT_CYCLE_STEPS

Line 47: FROM cs_incident_cycle_steps

43: l_count NUMBER;
44: BEGIN
45:
46: SELECT count(*) INTO l_count
47: FROM cs_incident_cycle_steps
48: WHERE incident_type_id = p_incident_type_id
49: AND trunc(sysdate) BETWEEN trunc(nvl(start_date_active, sysdate))
50: AND trunc(nvl(end_date_active, sysdate));
51: return l_count;