DBA Data[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;