DBA Data[Home] [Help]

APPS.GMD_RECIPE_VAL dependencies on GMD_STATUS

Line 754: FROM gmd_routings_b h,gmd_status s

750: FUNCTION check_routing_validity(p_routing_id NUMBER,
751: p_recipe_status VARCHAR2) RETURN BOOLEAN IS
752: CURSOR Cur_rtstatus_vldty IS
753: SELECT COUNT(*)
754: FROM gmd_routings_b h,gmd_status s
755: WHERE h.routing_id = p_routing_id AND
756: h.routing_status = s.status_code AND
757: to_number(h.routing_status) >= to_number(p_recipe_status) AND
758: -- Begin Bug#2402946 Ravi S Reddy