816:
817: -- B5259453, FPO can use planning and production validity rules
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