APPS.CSD_SOO_PVT dependencies on CS_INCIDENT_STATUSES

Line 163: from cs_incident_statuses

159: l_status_name varchar2(500);
160:
161: CURSOR c_sr_status_name(c_incident_status_id NUMBER) IS
162: SELECT name
163: from cs_incident_statuses
164: where trunc(sysdate) between nvl(start_date_active, sysdate - 1)
165: and nvl(end_date_active, sysdate + 1)
166: and incident_status_id = c_incident_status_id;
167: