APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_SYSTEMS_VL

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

2184:
2185: l_dummy NUMBER;
2186: l_return_value BOOLEAN := TRUE;
2187:
2188: -- Validate the System ID against CSI_SYSTEMS_VL table .
2189: BEGIN
2190:
2191: IF ((p_system_id IS NULL) OR
2192: (p_system_id = FND_API.G_MISS_NUM)) THEN

Line 2198: FROM csi_systems_vl

2194: ELSE
2195: BEGIN
2196: SELECT '1'
2197: INTO l_dummy
2198: FROM csi_systems_vl
2199: WHERE system_id = p_system_id
2200: AND ( (end_date_active is null) OR -- Fix for bug # 2783027
2201: (end_date_active > sysdate) );
2202: