DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_RECIPES

Line 3060: FROM gmd_recipes r, gmd_status s

3056: ;
3057:
3058: CURSOR c_recipe_id IS
3059: SELECT 1
3060: FROM gmd_recipes r, gmd_status s
3061: WHERE r.recipe_status = s.status_code
3062: AND r.recipe_id = p_sample.recipe_id
3063: AND s.status_type <> '1000'
3064: AND r.delete_mark = 0

Line 5469: FROM gmd_recipes

5465: AND bs.delete_mark = 0;
5466:
5467: CURSOR Cur_vrecipe IS
5468: SELECT recipe_no, recipe_version
5469: FROM gmd_recipes
5470: WHERE recipe_id = P_recipe_id;
5471:
5472: CURSOR Cur_vformula IS
5473: SELECT formula_no, formula_vers