APPS.PQP_CANDM_UPG dependencies on FF_FORMULAS_F

Line 62: FROM ff_formulas_f fff

58: ,fff.description
59: ,fff.sticky_flag
60: ,fff.compile_flag
61: ,paf.status_processing_rule_id status_processing_rule_id
62: FROM ff_formulas_f fff
63: ,PAY_STATUS_PROCESSING_RULES_F paf
64: --,pay_element_types_f petf
65: WHERE (formula_name
66: LIKE NVL(p_formula_name,'%_MILEAGE_CLAIM_PVT')

Line 85: FROM ff_formulas_f fff

81: ,fff.formula_name
82: ,substr(fff.formula_name,0,(length(fff.formula_name)-12)) fname
83: ,fff.business_group_id
84: ,paf.status_processing_rule_id
85: FROM ff_formulas_f fff
86: ,PAY_STATUS_PROCESSING_RULES_F paf
87: WHERE formula_name=cp_formula_name
88: AND fff.business_group_id=cp_business_group_id
89: AND fff.business_group_id=paf.business_group_id

Line 122: l_formula_type_id ff_formulas_f.formula_type_id%TYPE;

118: l_seq NUMBER;
119: l_st_date DATE;
120: l_end_date DATE;
121: l_bg_id NUMBER;
122: l_formula_type_id ff_formulas_f.formula_type_id%TYPE;
123:
124: l_ctr NUMBER;
125:
126: /********BEGIN************/

Line 160: 'SELECT formula_text FROM ff_formulas_f WHERE formula_name= :x AND sysdate BETWEEN

156: EXIT WHEN c_formula%NOTFOUND;
157: l_formula_name:=l_formula.formula_name;
158: l_short_formula_name := substr(l_formula.formula_name,0,(length(l_formula.formula_name)-18));
159: l_query:=
160: 'SELECT formula_text FROM ff_formulas_f WHERE formula_name= :x AND sysdate BETWEEN
161: effective_start_date and effective_end_date';
162:
163: BEGIN
164: l_cursor := dbms_sql.open_cursor;

Line 199: UPDATE ff_formulas_f

195: l_temp_text:=l_pvt_formula;
196:
197:
198: l_temp_text:= replace (l_temp_text,'',UPPER(REPLACE(l_short_formula_name,' ','_')));
199: UPDATE ff_formulas_f
200: SET formula_name = l_formula_name||l_dt||'BAK'
201: WHERE formula_name = l_formula_name
202: AND sysdate between effective_start_date and effective_end_date;
203:

Line 205: UPDATE ff_formulas_f_tl

201: WHERE formula_name = l_formula_name
202: AND sysdate between effective_start_date and effective_end_date;
203:
204:
205: UPDATE ff_formulas_f_tl
206: SET formula_name = l_formula_name||l_dt||'BAK'
207: WHERE formula_name = l_formula_name;
208:
209: INSERT INTO ff_formulas_f(

Line 209: INSERT INTO ff_formulas_f(

205: UPDATE ff_formulas_f_tl
206: SET formula_name = l_formula_name||l_dt||'BAK'
207: WHERE formula_name = l_formula_name;
208:
209: INSERT INTO ff_formulas_f(
210: FORMULA_ID
211: ,EFFECTIVE_START_DATE
212: ,EFFECTIVE_END_DATE
213: ,BUSINESS_GROUP_ID

Line 246: /* INSERT INTO ff_formulas_f_tl (

242: ,1
243: ,sysdate
244: );
245:
246: /* INSERT INTO ff_formulas_f_tl (
247: FORMULA_ID
248: ,LANGUAGE
249: ,SOURCE_LANG
250: ,FORMULA_NAME