[Home] [Help]
129: WHERE cii.instance_id = px_instance_asset_rec.instance_id;
130: --
131: CURSOR csi_a_location_cur IS
132: SELECT fa_location_id
133: FROM csi_a_locations
134: WHERE location_id = l_cii_location_id;
135:
136: CURSOR fa_location_units_cur IS
137: SELECT SUM(fdh.units_assigned)
2825: l_fa_location_id NUMBER := 0;
2826:
2827: CURSOR csi_a_location_cur( l_inst_location_id NUMBER) IS
2828: SELECT fa_location_id
2829: FROM csi_a_locations
2830: WHERE location_id = l_inst_location_id;
2831:
2832: BEGIN
2833: x_return_status := FND_API.G_RET_STS_SUCCESS ;