DBA Data[Home] [Help]

APPS.GMPRELAP dependencies on GMD_STATUS_B

Line 947: gmd_status_b gs

943: CURSOR Cur_get_eff_id IS
944: SELECT gr.recipe_id, count(1)
945: FROM gmd_recipes_b gr,
946: gmd_recipe_validity_rules grv,
947: gmd_status_b gs
948: WHERE grv.validity_rule_status in ('700','900')
949: AND gr.recipe_id = grv.recipe_id
950: AND grv.validity_rule_status = gs.status_code
951: AND gs.status_type in ('700','900')