APPS.CS_SERVICEREQUEST_UTIL dependencies on CS_INCIDENT_TYPES_VL_SEC
Line 1107: from cs_incident_types_vl_sec
1103: -- and trunc(nvl(end_date_active, sysdate));
1104:
1105: cursor val_type_secure is
1106: select cmro_flag, maintenance_flag ,start_date_active,end_date_active 1107: from cs_incident_types_vl_sec 1108: where incident_type_id = p_type_id
1109: and incident_subtype = p_subtype;
1110: -- and trunc(sysdate) between trunc(nvl(start_date_active, sysdate))
1111: -- and trunc(nvl(end_date_active, sysdate));