APPS.GMD_RECIPE_MIGRATION dependencies on DUAL

Line 137: FROM sys.DUAL

133:
134: /* Check if recipe customer exists */
135: Cursor check_recipe_cust_exists(v_recipe_id NUMBER, v_customer_id NUMBER) IS
136: SELECT 1
137: FROM sys.DUAL
138: WHERE EXISTS ( SELECT 1
139: FROM gmd_recipe_customers
140: WHERE recipe_id = v_recipe_id
141: AND customer_id = v_customer_id);

Line 146: FROM sys.DUAL

142:
143: /* Check if recipe step material exists */
144: Cursor check_step_mat_exists(v_recipe_id NUMBER, v_formulaline_id NUMBER) IS
145: SELECT 1
146: FROM sys.DUAL
147: WHERE EXISTS ( SELECT 1
148: FROM gmd_recipe_step_materials
149: WHERE recipe_id = v_recipe_id
150: AND formulaline_id = v_formulaline_id);

Line 163: FROM sys.DUAL

159: /* Check if the item id exists in ic_item_mst table */
160: CURSOR get_valid_item ( v_item_id NUMBER )
161: IS
162: SELECT 1
163: FROM sys.DUAL
164: WHERE EXISTS ( SELECT 1
165: FROM ic_item_mst
166: WHERE item_id = v_item_id
167: AND delete_mark = 0 );

Line 278: FROM sys.DUAL;

274:
275: /* Get the recipe id from the sequence */
276: SELECT gmd_recipe_id_s.NEXTVAL
277: INTO l_recipe_id
278: FROM sys.DUAL;
279: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */
280: /* This function return non zero value when the effectivity is locked */
281:
282: l_return_val := gmdfmval_pub.locked_effectivity_val (

Line 411: FROM sys.DUAL;

407: /* Get the recipe id from sequence */
408:
409: SELECT gmd_recipe_id_s.NEXTVAL
410: INTO l_recipe_id
411: FROM sys.DUAL;
412: /* function gmdfmval_pub.locked_effectivity_val gets the recipe status */
413: /* This function return non zero value when the effectivity is locked */
414:
415: l_return_val := gmdfmval_pub.locked_effectivity_val (

Line 922: FROM DUAL;

918: p_target_table,
919: p_source_id,
920: p_target_id,
921: p_message
922: FROM DUAL;
923: COMMIT;
924: END insert_message;
925:
926: PROCEDURE qty_update_fxd_scaling IS