APPS.AMS_FORMULA_PVT dependencies on DUAL

Line 357: l_sql_stmt := 'SELECT '||l_formula_entry_dets.formula_entry_value||'(:p1,:p2,:p3,:p4,:p5) FROM DUAL';

353: EXIT WHEN C_Formula_Entry_Dets%NOTFOUND;
354:
355: IF (l_formula_entry_dets.formula_entry_type = 'CALCULATION') THEN
356:
357: l_sql_stmt := 'SELECT '||l_formula_entry_dets.formula_entry_value||'(:p1,:p2,:p3,:p4,:p5) FROM DUAL';
358:
359:
360: EXECUTE IMMEDIATE l_sql_stmt INTO l_formula_entry_results(l_rec_counter).result USING p_hierarchy_id,p_parent_node_id,p_node_id,l_activity_metric_id,l_parent_formula_id;
361: l_sql_stmt := NULL;

Line 1661: FROM dual;

1657: WHERE formula_id = l_formula_id;
1658:
1659: CURSOR c_formula_id IS
1660: SELECT ams_act_metric_formulas_s.NEXTVAL
1661: FROM dual;
1662:
1663: BEGIN
1664:
1665: --

Line 1937: FROM dual;

1933: WHERE formula_entry_id = l_formula_entry_id;
1934:
1935: CURSOR c_formula_entry_id IS
1936: SELECT ams_act_metric_formula_ent_s.NEXTVAL
1937: FROM dual;
1938:
1939: BEGIN
1940:
1941: --