APPS.GME_COMMON_PVT dependencies on GMD_STATUS

Line 3818: FROM gmd_status gs, gmd_recipe_validity_rules grvr

3814: -- Check if the validity rule status is either 'OBSOLETE' or 'ON HOLD'.
3815: CURSOR cur_get_status_type (v_validity_rule_id NUMBER)
3816: IS
3817: SELECT status_type
3818: FROM gmd_status gs, gmd_recipe_validity_rules grvr
3819: WHERE grvr.recipe_validity_rule_id = v_validity_rule_id
3820: AND status_code = grvr.validity_rule_status;
3821:
3822: /* Local variables */