APPS.GME_COMMON_PVT dependencies on GMD_STATUS

Line 4077: FROM gmd_status gs, gmd_recipe_validity_rules grvr

4073: -- Check if the validity rule status is either 'OBSOLETE' or 'ON HOLD'.
4074: CURSOR cur_get_status_type (v_validity_rule_id NUMBER)
4075: IS
4076: SELECT status_type
4077: FROM gmd_status gs, gmd_recipe_validity_rules grvr
4078: WHERE grvr.recipe_validity_rule_id = v_validity_rule_id
4079: AND status_code = grvr.validity_rule_status;
4080:
4081: /* Local variables */