APPS.GMDFMVAL_PUB dependencies on DUAL

Line 590: SELECT 1 FROM sys.dual

586: l_status VARCHAR2(32) := '700';
587: iret NUMBER;
588:
589: CURSOR locked_val_cur(pfmeff_id NUMBER) IS
590: SELECT 1 FROM sys.dual
591: WHERE EXISTS (SELECT 1 FROM cm_cmpt_dtl
592: WHERE fmeff_id = pfmeff_id
593: AND rollover_ind = 1) ;
594: BEGIN

Line 1386: SELECT gmd_formula_substitution_s.nextval INTO x_newformsubs_id FROM DUAL;

1382: END IF;
1383: ELSE
1384: x_new_substitution_id := subs_rec.substitution_id;
1385: END IF;
1386: SELECT gmd_formula_substitution_s.nextval INTO x_newformsubs_id FROM DUAL;
1387:
1388: -- End of bug# 5354649
1389:
1390: -- Copy all substitution list specific to old formula into

Line 2114: FROM SYS.DUAL

2110: -------------------------------------------------------------------
2111: --Cursor fetches 1 if context formula has experied item(s)
2112: CURSOR cur_check_expr(p_org_id NUMBER) IS
2113: SELECT 1
2114: FROM SYS.DUAL
2115: WHERE EXISTS (SELECT 1
2116: FROM fm_matl_dtl d,
2117: mtl_system_items_b i
2118: WHERE recipe_enabled_flag ='Y'

Line 2199: FROM SYS.DUAL

2195: -------------------------------------------------------------------
2196: --Cursor fetches 1 if context formula has experied item(s)
2197: CURSOR cur_check_inactive IS
2198: SELECT 1
2199: FROM SYS.DUAL
2200: WHERE EXISTS (SELECT 1 FROM fm_matl_dtl d,
2201: mtl_system_items_b i
2202: WHERE d.formula_id = V_formula_id
2203: AND i.inventory_item_id = d.inventory_item_id