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