APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on CS_INCIDENT_SEVERITIES_VL

Line 4174: l_name cs_incident_severities_vl.name%type;

4170: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4171:
4172: --Local Variables for search results
4173: l_rownum NUMBER;
4174: l_name cs_incident_severities_vl.name%type;
4175: l_id NUMBER;
4176: l_desc cs_incident_severities_vl.description%type;
4177:
4178: BEGIN

Line 4176: l_desc cs_incident_severities_vl.description%type;

4172: --Local Variables for search results
4173: l_rownum NUMBER;
4174: l_name cs_incident_severities_vl.name%type;
4175: l_id NUMBER;
4176: l_desc cs_incident_severities_vl.description%type;
4177:
4178: BEGIN
4179:
4180: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4185: l_sql_string := l_sql_string || ' FROM cs_incident_severities_vl ';

4181:
4182: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
4183: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, name,';
4184: l_sql_string := l_sql_string || ' incident_severity_id, description ';
4185: l_sql_string := l_sql_string || ' FROM cs_incident_severities_vl ';
4186: l_sql_string := l_sql_string || ' WHERE trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate)) ';
4187: l_sql_string := l_sql_string || ' and incident_subtype = ''INC'' ';
4188: l_sql_string := l_sql_string || ' and name is not null ';
4189: