APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_SYSTEMS_VL

Line 2233: -- Validate the System ID against CSI_SYSTEMS_VL table .

2229:
2230: l_dummy NUMBER;
2231: l_return_value BOOLEAN := TRUE;
2232:
2233: -- Validate the System ID against CSI_SYSTEMS_VL table .
2234: BEGIN
2235:
2236: IF ((p_system_id IS NULL) OR
2237: (p_system_id = FND_API.G_MISS_NUM)) THEN

Line 2243: FROM csi_systems_vl

2239: ELSE
2240: BEGIN
2241: SELECT '1'
2242: INTO l_dummy
2243: FROM csi_systems_vl
2244: WHERE system_id = p_system_id
2245: AND ( (end_date_active is null) OR -- Fix for bug # 2783027
2246: (end_date_active > sysdate) );
2247: