APPS.HR_USER_INIT_DEDN dependencies on FF_FORMULAS_F

Line 540: FROM ff_formulas_f FF

536: if p_ele_processing_type = 'R' then
537:
538: SELECT FF.formula_text, FF.formula_type_id
539: INTO v_skeleton_formula_text, v_skeleton_formula_type_id
540: FROM ff_formulas_f FF
541: WHERE FF.formula_name = 'SYSTEM_DEDN_CALC_FORMULA'
542: AND FF.business_group_id IS NULL
543: AND FF.legislation_code = 'US'
544: AND FF.formula_id >= 0 --Bug 3349594

Line 552: FROM ff_formulas_f FF

548: else
549:
550: SELECT FF.formula_text, FF.formula_type_id
551: INTO v_skeleton_formula_text, v_skeleton_formula_type_id
552: FROM ff_formulas_f FF
553: WHERE FF.formula_name = 'SYSTEM_DEDN_CALC_NR_FORMULA'
554: AND FF.business_group_id IS NULL
555: AND FF.legislation_code = 'US'
556: AND FF.formula_id >= 0 --Bug 3349594

Line 709: INSERT INTO ff_formulas_f (

705: INTO v_formula_id
706: FROM sys.dual;
707:
708: hr_utility.set_location('hr_user_init_dedn.ins_formula',40);
709: INSERT INTO ff_formulas_f (
710: FORMULA_ID,
711: EFFECTIVE_START_DATE,
712: EFFECTIVE_END_DATE,
713: BUSINESS_GROUP_ID,

Line 4081: FROM ff_formulas_f FF

4077: IF UPPER(p_ele_start_rule) = 'CHAINED' THEN
4078: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',15);
4079: SELECT FF.formula_id
4080: INTO v_skip_formula_id
4081: FROM ff_formulas_f FF
4082: WHERE FF.formula_name = 'CHAINED_SKIP_FORMULA'
4083: AND FF.business_group_id IS NULL
4084: -- added legislation_code asasthan
4085: AND FF.legislation_code = 'US'

Line 4094: FROM ff_formulas_f FF

4090: ELSIF UPPER(p_ele_start_rule) = 'ET' THEN
4091: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',20);
4092: SELECT FF.formula_id
4093: INTO v_skip_formula_id
4094: FROM ff_formulas_f FF
4095: WHERE FF.formula_name = 'THRESHOLD_SKIP_FORMULA'
4096: AND FF.business_group_id IS NULL
4097: -- added legislation code asasthan
4098: AND FF.legislation_code = 'US'

Line 4108: FROM ff_formulas_f FF

4104: ELSE -- Just check skip rule and separate check flag.
4105: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',25);
4106: SELECT FF.formula_id
4107: INTO v_skip_formula_id
4108: FROM ff_formulas_f FF
4109: WHERE FF.formula_name = 'FREQ_RULE_SKIP_FORMULA'
4110: AND FF.legislation_code = 'US'
4111: AND FF.business_group_id IS NULL
4112: AND p_ele_eff_start_date >= FF.effective_start_date

Line 4926: FROM pay_status_processing_rules_f spr, ff_formulas_f ff

4922: AND business_group_id = p_business_group_id;
4923:
4924: CURSOR get_formulae(l_ele_id in number) IS
4925: SELECT distinct ff.formula_id
4926: FROM pay_status_processing_rules_f spr, ff_formulas_f ff
4927: WHERE spr.element_type_id = l_ele_id
4928: AND ff.formula_id = spr.formula_id
4929: AND ff.business_group_id = p_business_group_id;
4930:

Line 4933: FROM ff_formulas_f ff

4929: AND ff.business_group_id = p_business_group_id;
4930:
4931: CURSOR get_old_formulae(l_ele_name in varchar2) IS
4932: SELECT distinct ff.formula_id
4933: FROM ff_formulas_f ff
4934: WHERE ff.formula_name like upper('OLD%'||p_ele_name||'_FLAT%')
4935: OR ff.formula_name like upper('OLD%'||p_ele_name||'_PERCENT%')
4936: OR ff.formula_name like upper('OLD%'||p_ele_name||'_BENEFIT%')
4937: OR ff.formula_name like upper('OLD%'||p_ele_name||'_PAYROLL%')

Line 5223: -- FF_FORMULAS_F

5219:
5220: IF assoc_eles(i) IS NOT NULL THEN
5221:
5222: -- Get formula_ids to delete from various tables:
5223: -- FF_FORMULAS_F
5224: -- FF_FDI_USAGES_F
5225: -- FF_COMPILED_INFO_F
5226: --
5227: OPEN get_formulae(assoc_eles(i));

Line 5235: DELETE FROM ff_formulas_f

5231: EXIT WHEN get_formulae%NOTFOUND;
5232:
5233: begin
5234:
5235: DELETE FROM ff_formulas_f
5236: WHERE formula_id = v_ff_id;
5237:
5238: exception when NO_DATA_FOUND then
5239: null;

Line 5295: DELETE FROM ff_formulas_f

5291: EXIT WHEN get_old_formulae%NOTFOUND;
5292:
5293: begin
5294:
5295: DELETE FROM ff_formulas_f
5296: WHERE formula_id = v_ff_id;
5297:
5298: exception when NO_DATA_FOUND then
5299: null;