DBA Data[Home] [Help]

APPS.AHL_RM_PROD_ZONE_AS_PVT dependencies on AHL_ROUTES_APP_V

Line 751: FROM ahl_routes_app_v

747: WHERE prodtype_zone_id = c_prodtype_zone_id;
748:
749: CURSOR get_route_zone_rec(c_product_type_code VARCHAR2, c_zone_code VARCHAR2) IS
750: SELECT route_id
751: FROM ahl_routes_app_v
752: WHERE product_type_code = c_product_type_code
753: AND zone_code = c_zone_code;
754:
755: CURSOR get_route_sub_rec(c_product_type_code VARCHAR2, c_zone_code VARCHAR2,

Line 758: FROM ahl_routes_app_v

754:
755: CURSOR get_route_sub_rec(c_product_type_code VARCHAR2, c_zone_code VARCHAR2,
756: c_sub_zone_code VARCHAR2 ) IS
757: SELECT route_id
758: FROM ahl_routes_app_v
759: WHERE product_type_code = c_product_type_code
760: AND zone_code = c_zone_code
761: AND sub_zone_code = c_sub_zone_code;
762: