DBA Data[Home] [Help]

APPS.GMD_RECIPE_VAL dependencies on GMD_RECIPES_B

Line 72: from gmd_recipes_b

68: /* recipe_id given as parameter. */
69:
70: CURSOR get_record_with_recipe_id(vRecipe_id NUMBER) IS
71: select recipe_id
72: from gmd_recipes_b
73: where recipe_id = vRecipe_id;
74:
75: --Gjha 27-Dec-2004 Bug 4073815 . Removed the Upper of UPPER(recipe_no) to improve the performance. The uniqueness is
76: -- is to be maintained for case-sensitive Recipe_no and Recipe_version.

Line 80: from gmd_recipes_b

76: -- is to be maintained for case-sensitive Recipe_no and Recipe_version.
77: CURSOR get_record_without_recipe_id(vRecipe_no VARCHAR2
78: ,vRecipe_version NUMBER) IS
79: select recipe_id
80: from gmd_recipes_b
81: where recipe_no = vRecipe_no
82: and recipe_version = vRecipe_version;
83:
84: /*** Variables ***/

Line 167: from gmd_recipes_b

163: x_recipe_id OUT NOCOPY NUMBER)
164: IS
165: CURSOR get_record IS
166: select recipe_id
167: from gmd_recipes_b
168: where recipe_no = p_recipe_no
169: and recipe_version = p_recipe_version;
170:
171: /*** Variables ***/