eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_USER_INIT_DEDN dependencies on FF_FORMULAS_F

Line 263: 13-Nov-2011 emunisek 115.28 13484606 Replaced FF_FORMULAS_F.FORMULA_TEXT%TYPE

259: with Dimension _ENTRY_ITD.
260: 17-NOV-2008 sudedas 115.26 7535681 Procedure do_deletions is modified
261: to remove ' Refund' element/balance
262: when "EE Series Bond" is checked.
263: 13-Nov-2011 emunisek 115.28 13484606 Replaced FF_FORMULAS_F.FORMULA_TEXT%TYPE
264: for variables based on formula_text column.
265: 22-Dec-2011 emunisek 115.29 13512417 Attached Dimension '_ENTRY_ITD' to Primary Balance
266: of Deduction Element. Added '_ASG_PTD' Dimension
267: to Accrued Balance of Deduction Element. Added

Line 538: v_skeleton_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;

534: RETURN number IS
535: -- local vars
536: v_formula_id number; -- Return var
537: --
538: v_skeleton_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
539: v_skeleton_formula_type_id NUMBER(9);
540: v_ele_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
541: v_ele_formula_name VARCHAR2(80);
542: v_ele_formula_id NUMBER(9);

Line 540: v_ele_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;

536: v_formula_id number; -- Return var
537: --
538: v_skeleton_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
539: v_skeleton_formula_type_id NUMBER(9);
540: v_ele_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
541: v_ele_formula_name VARCHAR2(80);
542: v_ele_formula_id NUMBER(9);
543: v_ele_name VARCHAR2(80);
544:

Line 552: FROM ff_formulas_f FF

548: if p_ele_processing_type = 'R' then
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_FORMULA'
554: AND FF.business_group_id IS NULL
555: AND FF.legislation_code = 'US'
556: AND FF.formula_id >= 0 --Bug 3349594

Line 564: FROM ff_formulas_f FF

560: else
561:
562: SELECT FF.formula_text, FF.formula_type_id
563: INTO v_skeleton_formula_text, v_skeleton_formula_type_id
564: FROM ff_formulas_f FF
565: WHERE FF.formula_name = 'SYSTEM_DEDN_CALC_NR_FORMULA'
566: AND FF.business_group_id IS NULL
567: AND FF.legislation_code = 'US'
568: AND FF.formula_id >= 0 --Bug 3349594

Line 721: INSERT INTO ff_formulas_f (

717: INTO v_formula_id
718: FROM sys.dual;
719:
720: hr_utility.set_location('hr_user_init_dedn.ins_formula',40);
721: INSERT INTO ff_formulas_f (
722: FORMULA_ID,
723: EFFECTIVE_START_DATE,
724: EFFECTIVE_END_DATE,
725: BUSINESS_GROUP_ID,

Line 4189: FROM ff_formulas_f FF

4185: IF UPPER(p_ele_start_rule) = 'CHAINED' THEN
4186: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',15);
4187: SELECT FF.formula_id
4188: INTO v_skip_formula_id
4189: FROM ff_formulas_f FF
4190: WHERE FF.formula_name = 'CHAINED_SKIP_FORMULA'
4191: AND FF.business_group_id IS NULL
4192: -- added legislation_code asasthan
4193: AND FF.legislation_code = 'US'

Line 4202: FROM ff_formulas_f FF

4198: ELSIF UPPER(p_ele_start_rule) = 'ET' THEN
4199: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',20);
4200: SELECT FF.formula_id
4201: INTO v_skip_formula_id
4202: FROM ff_formulas_f FF
4203: WHERE FF.formula_name = 'THRESHOLD_SKIP_FORMULA'
4204: AND FF.business_group_id IS NULL
4205: -- added legislation code asasthan
4206: AND FF.legislation_code = 'US'

Line 4216: FROM ff_formulas_f FF

4212: ELSE -- Just check skip rule and separate check flag.
4213: hr_utility.set_location('hr_user_init_dedn.ins_dedn_ele_type',25);
4214: SELECT FF.formula_id
4215: INTO v_skip_formula_id
4216: FROM ff_formulas_f FF
4217: WHERE FF.formula_name = 'FREQ_RULE_SKIP_FORMULA'
4218: AND FF.legislation_code = 'US'
4219: AND FF.business_group_id IS NULL
4220: AND p_ele_eff_start_date >= FF.effective_start_date

Line 5052: FROM pay_status_processing_rules_f spr, ff_formulas_f ff

5048: AND business_group_id = p_business_group_id;
5049:
5050: CURSOR get_formulae(l_ele_id in number) IS
5051: SELECT distinct ff.formula_id
5052: FROM pay_status_processing_rules_f spr, ff_formulas_f ff
5053: WHERE spr.element_type_id = l_ele_id
5054: AND ff.formula_id = spr.formula_id
5055: AND ff.business_group_id = p_business_group_id;
5056:

Line 5059: FROM ff_formulas_f ff

5055: AND ff.business_group_id = p_business_group_id;
5056:
5057: CURSOR get_old_formulae(l_ele_name in varchar2) IS
5058: SELECT distinct ff.formula_id
5059: FROM ff_formulas_f ff
5060: WHERE ff.formula_name like upper('OLD%'||p_ele_name||'_FLAT%')
5061: OR ff.formula_name like upper('OLD%'||p_ele_name||'_PERCENT%')
5062: OR ff.formula_name like upper('OLD%'||p_ele_name||'_BENEFIT%')
5063: OR ff.formula_name like upper('OLD%'||p_ele_name||'_PAYROLL%')

Line 5382: -- FF_FORMULAS_F

5378:
5379: IF assoc_eles(i) IS NOT NULL THEN
5380:
5381: -- Get formula_ids to delete from various tables:
5382: -- FF_FORMULAS_F
5383: -- FF_FDI_USAGES_F
5384: -- FF_COMPILED_INFO_F
5385: --
5386: OPEN get_formulae(assoc_eles(i));

Line 5394: DELETE FROM ff_formulas_f

5390: EXIT WHEN get_formulae%NOTFOUND;
5391:
5392: begin
5393:
5394: DELETE FROM ff_formulas_f
5395: WHERE formula_id = v_ff_id;
5396:
5397: exception when NO_DATA_FOUND then
5398: null;

Line 5454: DELETE FROM ff_formulas_f

5450: EXIT WHEN get_old_formulae%NOTFOUND;
5451:
5452: begin
5453:
5454: DELETE FROM ff_formulas_f
5455: WHERE formula_id = v_ff_id;
5456:
5457: exception when NO_DATA_FOUND then
5458: null;