DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_INCIDENT_SEVERITIES_VL

Line 2947: FROM cs_incident_severities_vl csv,

2943:
2944: CURSOR cs_severity_in_eam_priority
2945: IS
2946: SELECT 'x'
2947: FROM cs_incident_severities_vl csv,
2948: mfg_lookups mfl
2949: WHERE mfl.lookup_code = csv.incident_severity_id AND
2950: csv.incident_severity_id = p_x_nonroutine_rec.severity_id AND
2951: csv.incident_subtype = 'INC' AND

Line 3072: FROM cs_incident_severities_vl

3068: THEN
3069: BEGIN
3070: SELECT incident_severity_id
3071: INTO p_x_nonroutine_rec.severity_id
3072: FROM cs_incident_severities_vl
3073: WHERE name = p_x_nonroutine_rec.severity_name and
3074: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
3075: EXCEPTION
3076: WHEN NO_DATA_FOUND THEN