APPS.PQP_CANDM_UPG dependencies on FF_FORMULAS_F

Line 113: FROM ff_formulas_f fff

109: ,fff.compile_flag
110: ,paf.status_processing_rule_id status_processing_rule_id
111: ,fff.formula_text
112: ,fff.legislation_code
113: FROM ff_formulas_f fff
114: ,PAY_STATUS_PROCESSING_RULES_F paf
115: WHERE fff.formula_name like NVL(p_formula_name,p_formula_cat)
116: AND fff.formula_id=paf.formula_id
117: AND paf.assignment_status_type_id IS NULL

Line 131: l_formula_text_buffer ff_formulas_f.formula_text%TYPE;

127:
128: l_formula c_formula_details%ROWTYPE;
129: l_formula_ver VARCHAR2(50);
130: l_formula_prefix VARCHAR2(50);
131: l_formula_text_buffer ff_formulas_f.formula_text%TYPE;
132:
133: l_year VARCHAR2(30);
134:
135:

Line 172: UPDATE ff_formulas_f

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;
175:
176: UPDATE ff_formulas_f_tl

Line 176: UPDATE ff_formulas_f_tl

172: UPDATE ff_formulas_f
173: SET formula_name = l_formula.formula_name||'_'||l_year||'_BAK'
174: WHERE formula_id = l_formula.formula_id;
175:
176: UPDATE ff_formulas_f_tl
177: SET formula_name = l_formula.formula_name||'_'||l_year||'_BAK'
178: WHERE formula_id = l_formula.formula_id;
179:
180: INSERT INTO ff_formulas_f(

Line 180: INSERT INTO ff_formulas_f(

176: UPDATE ff_formulas_f_tl
177: SET formula_name = l_formula.formula_name||'_'||l_year||'_BAK'
178: WHERE formula_id = l_formula.formula_id;
179:
180: INSERT INTO ff_formulas_f(
181: FORMULA_ID
182: ,EFFECTIVE_START_DATE
183: ,EFFECTIVE_END_DATE
184: ,BUSINESS_GROUP_ID