APPS.CSI_ASSET_VLD_PVT dependencies on CSI_ITEM_INSTANCES

Line 83: FROM csi_item_instances

79: l_return_value BOOLEAN := TRUE;
80:
81: CURSOR c1 IS
82: SELECT 'x'
83: FROM csi_item_instances
84: WHERE instance_id = p_instance_id
85: and ((active_end_date is null) OR (active_end_date >= sysdate));
86:
87: CURSOR c2 IS

Line 89: FROM csi_item_instances

85: and ((active_end_date is null) OR (active_end_date >= sysdate));
86:
87: CURSOR c2 IS
88: SELECT 'x'
89: FROM csi_item_instances
90: WHERE instance_id = p_instance_id;
91: BEGIN
92: IF p_check_for_instance_expiry = fnd_api.g_true THEN
93: OPEN c1;

Line 377: FROM csi_item_instances

373:
374: CURSOR c1 IS
375: SELECT active_start_date,
376: active_end_date
377: FROM csi_item_instances
378: WHERE instance_id = p_instance_id
379: AND ((active_end_date IS NULL) OR (active_end_date >= SYSDATE));
380: BEGIN
381: IF ((p_end_date IS NOT NULL) AND (p_end_date <> FND_API.G_MISS_DATE))THEN

Line 454: FROM csi_item_instances

450:
451: CURSOR c1 IS
452: SELECT active_start_date,
453: active_end_date
454: FROM csi_item_instances
455: WHERE instance_id = p_instance_id;
456:
457: l_date_rec c1%ROWTYPE;
458: