APPS.AHL_RM_PROD_ZONE_AS_PVT dependencies on AHL_ROUTES_B

Line 1092: UPDATE AHL_ROUTES_B

1088: WHERE product_type_code = l_get_prod_zone_rec.product_type_code
1089: AND zone_code = l_get_prod_zone_rec.zone_code;
1090: FOR I IN get_route_zone_rec(l_get_prod_zone_rec.product_type_code,
1091: l_get_prod_zone_rec.zone_code) LOOP
1092: UPDATE AHL_ROUTES_B
1093: SET zone_code = NULL,
1094: sub_zone_code = NULL
1095: WHERE route_id = I.route_id;
1096: END LOOP;

Line 1100: UPDATE AHL_ROUTES_B

1096: END LOOP;
1097: ELSE
1098: FOR I IN get_route_sub_rec(l_get_prod_zone_rec.product_type_code,
1099: l_get_prod_zone_rec.zone_code, l_get_prod_zone_rec.sub_zone_code ) LOOP
1100: UPDATE AHL_ROUTES_B
1101: SET sub_zone_code = NULL
1102: WHERE route_id= I.route_id;
1103: END LOOP;
1104: END IF;