APPS.HR_USER_DEDN_DRV dependencies on FF_FORMULAS_F

Line 43: 13-Nov-11 emunisek 115.5 13484606 Replaced FF_FORMULAS_F.FORMULA_TEXT%TYPE

39: 07-Jan-04 kaverma 115.3 3349575 Modified query in insert_formula
40: to remove Full Table Scan
41: 07-Jan-04 kaverma 115.3 3349575 Modified query in insert_formula
42: to correct the join condition
43: 13-Nov-11 emunisek 115.5 13484606 Replaced FF_FORMULAS_F.FORMULA_TEXT%TYPE
44: for variables based on formula_text column.
45:
46:
47: */

Line 85: r_skeleton_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;

81: -- local vars
82: r_formula_id number; -- Return var
83: --
84: r_description VARCHAR2(240);
85: r_skeleton_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
86: r_skeleton_formula_type_id NUMBER(9);
87: r_ele_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
88: r_ele_formula_name VARCHAR2(80);
89: r_ele_name VARCHAR2(80);

Line 87: r_ele_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;

83: --
84: r_description VARCHAR2(240);
85: r_skeleton_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
86: r_skeleton_formula_type_id NUMBER(9);
87: r_ele_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
88: r_ele_formula_name VARCHAR2(80);
89: r_ele_name VARCHAR2(80);
90:
91: BEGIN

Line 95: FROM ff_formulas_f FF

91: BEGIN
92: hr_utility.set_location('pyusddwp.insert_formula',10);
93: SELECT FF.formula_text, FF.formula_type_id, FF.description
94: INTO r_skeleton_formula_text, r_skeleton_formula_type_id, r_description
95: FROM ff_formulas_f FF
96: WHERE FF.formula_name = p_ff_formula_name
97: AND FF.business_group_id IS NULL
98: AND FF.legislation_code = 'US'
99: AND p_eff_start_date between FF.effective_start_date and FF.effective_end_date

Line 125: INSERT INTO ff_formulas_f (

121: INTO r_formula_id
122: FROM sys.dual;
123:
124: hr_utility.set_location('pyusddwp.insert_formula',40);
125: INSERT INTO ff_formulas_f (
126: FORMULA_ID,
127: EFFECTIVE_START_DATE,
128: EFFECTIVE_END_DATE,
129: BUSINESS_GROUP_ID,