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_EARN dependencies on FF_FORMULAS_F

Line 199: 21-DEC-2001 ahanda 115.15 1902232 Changed insert into ff_formulas_f

195: create_reduce_regpay_feeds procedure to not
196: return balance that are fed via the
197: element classification balance feeder
198: processes.
199: 21-DEC-2001 ahanda 115.15 1902232 Changed insert into ff_formulas_f
200: to insert null for legislation_code.
201: 22-JAN-2002 ahanda 115.16 Added call to create_defined_balance
202: ID for 'Assignment Payments' dimension.
203:

Line 273: 13-Nov-2011 emunisek 115.37 Bug 13484606 Replaced FF_FORMULAS_F.FORMULA_TEXT%TYPE

269: Modified the procedure ins_uie_input_vals
270: so that MANDATORY Flag is set to 'N'
271: for the input value 'Deduction Processing'
272: in case of 'Non-payroll Payments' Elements
273: 13-Nov-2011 emunisek 115.37 Bug 13484606 Replaced FF_FORMULAS_F.FORMULA_TEXT%TYPE
274: for variables based on formula_text column.
275:
276: */
277: --

Line 482: v_skeleton_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;

478:
479: -- local vars
480: v_formula_id number; -- Return var
481: --
482: v_skeleton_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
483: v_skeleton_formula_type_id NUMBER(9);
484: v_ele_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
485: v_ele_formula_name VARCHAR2(80);
486: v_ele_formula_id NUMBER(9);

Line 484: v_ele_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;

480: v_formula_id number; -- Return var
481: --
482: v_skeleton_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
483: v_skeleton_formula_type_id NUMBER(9);
484: v_ele_formula_text FF_FORMULAS_F.FORMULA_TEXT%TYPE;
485: v_ele_formula_name VARCHAR2(80);
486: v_ele_formula_id NUMBER(9);
487: v_ele_name VARCHAR2(80);
488: v_formula_name VARCHAR2(80);

Line 500: -- Bug 3768726 - Index FF_FORMULAS_F_UK2 is modified for bug 3768764. So ff.formula_id >= 0 is not needed.

496: v_formula_name := UPPER(p_amt_rule);
497:
498: -- Bug 3349586 - Condition for formula_id added to improve performance.
499: --
500: -- Bug 3768726 - Index FF_FORMULAS_F_UK2 is modified for bug 3768764. So ff.formula_id >= 0 is not needed.
501:
502: SELECT FF.formula_text, FF.formula_type_id
503: INTO v_skeleton_formula_text, v_skeleton_formula_type_id
504: FROM ff_formulas_f FF

Line 504: FROM ff_formulas_f FF

500: -- Bug 3768726 - Index FF_FORMULAS_F_UK2 is modified for bug 3768764. So ff.formula_id >= 0 is not needed.
501:
502: SELECT FF.formula_text, FF.formula_type_id
503: INTO v_skeleton_formula_text, v_skeleton_formula_type_id
504: FROM ff_formulas_f FF
505: WHERE FF.formula_name = v_formula_name --UPPER(FF.formula_name) = UPPER(p_amt_rule)
506: AND FF.business_group_id IS NULL
507: AND FF.legislation_code = 'US'
508: AND g_eff_start_date BETWEEN FF.effective_start_date

Line 531: INSERT INTO ff_formulas_f (

527: INTO v_formula_id
528: FROM sys.dual;
529: --
530: hr_utility.set_location('hr_user_init_earn.ins_formula',40);
531: INSERT INTO ff_formulas_f (
532: FORMULA_ID,
533: EFFECTIVE_START_DATE,
534: EFFECTIVE_END_DATE,
535: BUSINESS_GROUP_ID,

Line 2085: FROM ff_formulas_f

2081:
2082: hr_utility.set_location('pyusuiet',465);
2083: SELECT formula_id
2084: INTO v_val_formula_id
2085: FROM ff_formulas_f
2086: WHERE business_group_id IS NULL
2087: AND legislation_code = 'US'
2088: AND formula_name = 'JURISDICTION_VALIDATION';
2089: --

Line 4222: FROM ff_formulas_f FF

4218: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4219: --
4220: SELECT FF.formula_id
4221: INTO v_skip_formula_id
4222: FROM ff_formulas_f FF
4223: WHERE FF.formula_name = 'REGULAR_EARNINGS'
4224: AND FF.formula_id >= 0
4225: AND FF.business_group_id IS NULL
4226: AND legislation_code = g_template_leg_code

Line 4237: FROM ff_formulas_f FF

4233: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4234: --
4235: SELECT FF.formula_id
4236: INTO v_skip_formula_id
4237: FROM ff_formulas_f FF
4238: WHERE FF.formula_name = 'SUPPLEMENTAL_EARNINGS'
4239: AND FF.formula_id >= 0
4240: AND FF.business_group_id IS NULL
4241: AND legislation_code = g_template_leg_code

Line 4258: FROM ff_formulas_f FF

4254: --Bug 3349586 - Condition for formula_id added to remove use of non-mergable view
4255: --
4256: SELECT FF.formula_id
4257: INTO v_skip_formula_id
4258: FROM ff_formulas_f FF
4259: WHERE FF.formula_name = 'SUPPLEMENTAL_EARNINGS'
4260: AND FF.formula_id >= 0
4261: AND FF.business_group_id IS NULL
4262: AND legislation_code = g_template_leg_code

Line 4694: FROM ff_formulas_f

4690: /*
4691: hr_utility.set_location('pyusuiet',1066);
4692: SELECT formula_id
4693: INTO v_payval_formula_id
4694: FROM ff_formulas_f
4695: WHERE business_group_id IS NULL
4696: AND legislation_code = 'US'
4697: AND formula_name = 'PAYVALUE_VALIDATION';
4698:

Line 5369: -- FF_FORMULAS_F

5365: v_del_val_start := nvl(p_del_val_start_date, sysdate);
5366: v_del_sess_date := nvl(p_del_sess_date, sysdate);
5367: --
5368: -- Get formula_ids to delete from various tables:
5369: -- FF_FORMULAS_F
5370: -- FF_FDI_USAGES_F
5371: -- FF_COMPILED_INFO_F
5372: --
5373: OPEN get_formulae;

Line 5379: DELETE FROM ff_formulas_f

5375: FETCH get_formulae INTO v_ff_id;
5376: EXIT WHEN get_formulae%NOTFOUND;
5377: hr_utility.set_location('pyusuidt',1235);
5378:
5379: DELETE FROM ff_formulas_f
5380: WHERE formula_id = v_ff_id;
5381:
5382: begin
5383: