APPS.CSI_PRICING_ATTRIB_VLD_PVT dependencies on CSI_ITEM_INSTANCES

Line 32: FROM csi_item_instances

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

Line 119: FROM csi_item_instances

115: l_return_value BOOLEAN := TRUE;
116: CURSOR c1 IS
117: SELECT active_start_date,
118: active_end_date
119: FROM csi_item_instances
120: WHERE instance_id = p_instance_id;
121: l_date_rec c1%ROWTYPE;
122:
123: BEGIN

Line 195: FROM csi_item_instances

191:
192: CURSOR c1 IS
193: SELECT active_start_date,
194: active_end_date
195: FROM csi_item_instances
196: WHERE instance_id = p_instance_id;
197:
198: l_date_rec c1%ROWTYPE;
199: