DBA Data[Home] [Help]

APPS.AHL_UMP_NONROUTINES_PVT dependencies on CS_INCIDENT_SEVERITIES_VL

Line 2853: FROM cs_incident_severities_vl csv,

2849:
2850: CURSOR cs_severity_in_eam_priority
2851: IS
2852: SELECT 'x'
2853: FROM cs_incident_severities_vl csv,
2854: mfg_lookups mfl
2855: WHERE mfl.lookup_code = csv.incident_severity_id AND
2856: csv.incident_severity_id = p_x_nonroutine_rec.severity_id AND
2857: csv.incident_subtype = 'INC' AND

Line 2955: FROM cs_incident_severities_vl

2951: THEN
2952: BEGIN
2953: SELECT incident_severity_id
2954: INTO p_x_nonroutine_rec.severity_id
2955: FROM cs_incident_severities_vl
2956: WHERE name = p_x_nonroutine_rec.severity_name and
2957: trunc(sysdate) between trunc(nvl(start_date_active, sysdate)) and trunc(nvl(end_date_active, sysdate));
2958: EXCEPTION
2959: WHEN NO_DATA_FOUND THEN