818: CURSOR Cur_get_eff_id IS
819: SELECT gr.recipe_id, count(1)
820: FROM gmd_recipes_b gr,
821: gmd_recipe_validity_rules grv, 822: gmd_status_b gs 823: WHERE grv.validity_rule_status in ('700','900')
824: AND gr.recipe_id = grv.recipe_id
825: AND grv.validity_rule_status = gs.status_code
826: AND gs.status_type in ('700','900')