APPS.PQP_CANDM_UPG dependencies on FF_FORMULAS_S

Line 198: ff_formulas_s.nextval

194: ,LAST_UPDATE_LOGIN
195: ,CREATED_BY
196: ,CREATION_DATE )
197: VALUES(
198: ff_formulas_s.nextval
199: ,l_formula.EFFECTIVE_START_DATE
200: ,l_formula.EFFECTIVE_end_DATE
201: ,l_formula.business_group_id
202: ,l_formula.legislation_code

Line 217: SET formula_id=ff_formulas_s.currval

213: ,sysdate
214: );
215:
216: UPDATE pay_status_processing_rules_f
217: SET formula_id=ff_formulas_s.currval
218: WHERE status_processing_rule_id=l_formula.status_processing_rule_id
219: AND SYSDATE BETWEEN effective_start_date and effective_end_date;
220:
221: fnd_file.put_line(fnd_file.output,'The Fast Formula '||l_formula.formula_name||' is successfully upgraded');