DBA Data[Home] [Help]

APPS.GMD_CONC_REPLACE_PKG dependencies on GEM_LOOKUPS

Line 552: FROM Gem_lookups

548: -- Internal Functions
549: FUNCTION get_recipe_use(vRecipe_use VARCHAR2) Return VARCHAR2 IS
550: CURSOR recipe_use_meaning(vRecipe_use VARCHAR2) IS
551: SELECT meaning
552: FROM Gem_lookups
553: WHERE lookup_type = 'GMD_FORMULA_USE'
554: AND lookup_code = vRecipe_use;
555:
556: l_recipe_use VARCHAR2(100);

Line 632: FROM Gem_lookups

628: -- To retrieve the recipe_type
629: FUNCTION get_recipe_type(vRecipe_type VARCHAR2) Return VARCHAR2 IS
630: CURSOR recipe_type_meaning(vRecipe_type VARCHAR2) IS
631: SELECT meaning
632: FROM Gem_lookups
633: WHERE lookup_type = 'GMD_RECIPE_TYPE'
634: AND lookup_code = vRecipe_type;
635:
636: l_recipe_type VARCHAR2(100);