APPS.AHL_PRD_LOV_SERVICE_PVT dependencies on CS_INCIDENT_SEVERITIES_VL

Line 4320: l_name cs_incident_severities_vl.name%type;

4316: l_cur AHL_OSP_UTIL_PKG.ahl_search_csr;
4317:
4318: --Local Variables for search results
4319: l_rownum NUMBER;
4320: l_name cs_incident_severities_vl.name%type;
4321: l_id NUMBER;
4322: l_desc cs_incident_severities_vl.description%type;
4323:
4324: BEGIN

Line 4322: l_desc cs_incident_severities_vl.description%type;

4318: --Local Variables for search results
4319: l_rownum NUMBER;
4320: l_name cs_incident_severities_vl.name%type;
4321: l_id NUMBER;
4322: l_desc cs_incident_severities_vl.description%type;
4323:
4324: BEGIN
4325:
4326: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4327:
4328: -- SELECT CLAUSE AND BASIC WHERE CONDITIONS
4329: l_sql_string := 'SELECT * FROM ( SELECT Rownum RN, name,';
4330: l_sql_string := l_sql_string || ' incident_severity_id, description ';
4331: l_sql_string := l_sql_string || ' FROM cs_incident_severities_vl ';
4332: l_sql_string := l_sql_string || ' WHERE trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate)) ';
4333: l_sql_string := l_sql_string || ' and incident_subtype = ''INC'' ';
4334: l_sql_string := l_sql_string || ' and name is not null ';
4335: