APPS.GMD_RECIPE_HEADER_PVT dependencies on DUAL

Line 230: FROM sys.dual;

226: /* recipe id */
227: /* ===================================== */
228: IF (p_recipe_header_rec.recipe_id IS NULL) THEN
229: SELECT gmd_recipe_id_s.nextval INTO l_recipe_id
230: FROM sys.dual;
231: ELSE
232: l_recipe_id := p_recipe_header_rec.recipe_id;
233: END IF;
234:

Line 809: FROM sys.dual;

805: IF p_recipe_header_rec.recipe_id IS NULL THEN
806: -- Generate Recipe Id from sequence
807: SELECT gmd_recipe_id_s.nextval
808: INTO l_recipe_header_rec.recipe_id
809: FROM sys.dual;
810: ELSE -- Recipe id has been provided
811: -- Chcek if Recipe id is not a negative number
812: IF p_recipe_header_rec.recipe_id < 0 THEN
813: fnd_message.set_name('GMD', 'GMD_RECIPE_NOT_VALID');