DBA Data[Home] [Help]

APPS.PQP_CANDM_UPG dependencies on FF_FORMULAS_S

Line 228: ff_formulas_s.nextval

224: ,CREATED_BY
225: ,CREATION_DATE )
226:
227: VALUES(
228: ff_formulas_s.nextval
229: ,l_formula.EFFECTIVE_START_DATE
230: ,l_formula.EFFECTIVE_end_DATE
231: ,l_formula.business_group_id
232: ,NULL

Line 258: (ff_formulas_s.currval

254: ,LAST_UPDATE_LOGIN
255: ,CREATED_BY
256: ,CREATION_DATE )
257: VALUES
258: (ff_formulas_s.currval
259: ,'US'
260: ,'US'
261: ,l_formula.formula_name
262: ,l_formula.description

Line 271: SET formula_id=ff_formulas_s.currval

267: ,sysdate
268: );*/
269:
270: UPDATE pay_status_processing_rules_f
271: SET formula_id=ff_formulas_s.currval
272: WHERE status_processing_rule_id=l_formula.status_processing_rule_id
273: AND sysdate BETWEEN effective_start_date and effective_end_date;
274:
275: