DBA Data[Home] [Help]

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));