DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on GMD_RECIPES

Line 3655: FROM gmd_recipes r, gmd_status s

3651: ;
3652:
3653: CURSOR c_recipe_id IS
3654: SELECT 1
3655: FROM gmd_recipes r, gmd_status s
3656: WHERE r.recipe_status = s.status_code
3657: AND r.recipe_id = p_sample.recipe_id
3658: AND s.status_type <> '1000'
3659: AND r.delete_mark = 0

Line 6137: FROM gmd_recipes

6133: AND bs.delete_mark = 0;
6134:
6135: CURSOR Cur_vrecipe IS
6136: SELECT recipe_no, recipe_version
6137: FROM gmd_recipes
6138: WHERE recipe_id = P_recipe_id;
6139:
6140: CURSOR Cur_vformula IS
6141: SELECT formula_no, formula_vers