DBA Data[Home] [Help]

APPS.CSI_ASSET_PVT dependencies on CSI_A_LOCATIONS

Line 133: FROM csi_a_locations

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)

Line 2829: FROM csi_a_locations

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 ;