DBA Data[Home] [Help]

APPS.HR_USER_DEDN_DRV dependencies on FF_FORMULAS_F

Line 94: FROM ff_formulas_f FF

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

Line 124: INSERT INTO ff_formulas_f (

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