APPS.CSI_ORG_UNIT_VLD_PVT dependencies on CSI_ITEM_INSTANCES

Line 33: FROM csi_item_instances

29: ELSE
30: BEGIN
31: SELECT '1'
32: INTO l_instance_id
33: FROM csi_item_instances
34: WHERE instance_id = p_instance_id
35: AND ((active_end_date is NULL) OR (active_end_date >= SYSDATE));
36: RETURN TRUE;
37: EXCEPTION

Line 114: FROM csi_item_instances

110: l_return_value BOOLEAN := TRUE;
111: CURSOR c1 IS
112: SELECT active_start_date,
113: active_end_date
114: FROM csi_item_instances
115: WHERE instance_id = p_instance_id ;
116: l_date_rec c1%ROWTYPE;
117: BEGIN
118: IF ((p_start_date IS NULL) OR (p_start_date = FND_API.G_MISS_DATE)) THEN

Line 190: FROM csi_item_instances

186:
187: CURSOR c1 IS
188: SELECT active_end_date,
189: active_start_date
190: FROM csi_item_instances
191: WHERE instance_id = p_instance_id ;
192: l_date_rec c1%ROWTYPE;
193:
194: BEGIN