DBA Data[Home] [Help]

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