[Home] [Help]
APPS.PQP_CANDM_UPG dependencies on DUAL
Line 170: FROM DUAL;
166: l_formula_text_buffer := replace(l_sh_formula_text,'',UPPER(REPLACE(l_formula_prefix,' ','_')));
167:
168: SELECT TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS')
169: INTO l_year
170: FROM DUAL;
171:
172: UPDATE ff_formulas_f
173: SET formula_name = l_formula.formula_name||'_'||l_year||'_BAK'
174: WHERE formula_id = l_formula.formula_id;