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

Line 661: FROM ff_formulas_f FF

657: SELECT FF.formula_text,
658: FF.formula_type_id
659: INTO v_skeleton_formula_text,
660: v_skeleton_formula_type_id
661: FROM ff_formulas_f FF
662: WHERE FF.formula_name = 'PRETAX_WITHHOLDING_FORMULA'
663: AND FF.business_group_id IS NULL
664: AND FF.legislation_code = 'US'
665: AND g_eff_start_date >= FF.effective_start_date

Line 711: INSERT INTO ff_formulas_f ( FORMULA_ID,

707: hr_utility.set_location('hr_generate_pretax.ins_base_formula',40);
708:
709: -- hr_utility.trace('Inserting ff '||v_new_ele_formula_name||' for ele '||p_ff_ele_name);
710:
711: INSERT INTO ff_formulas_f ( FORMULA_ID,
712: EFFECTIVE_START_DATE,
713: EFFECTIVE_END_DATE,
714: BUSINESS_GROUP_ID,
715: LEGISLATION_CODE,

Line 761: UPDATE ff_formulas_f

757:
758: hr_utility.set_location('hr_generate_pretax.ins_base_formula',70);
759:
760: /*
761: UPDATE ff_formulas_f
762: SET formula_name = v_new_ele_formula_name,
763: formula_text = v_new_ele_formula_text
764: WHERE formula_id = v_new_ele_formula_id
765: AND business_group_id = p_ff_bg_id

Line 769: UPDATE ff_formulas_f

765: AND business_group_id = p_ff_bg_id
766: AND g_eff_start_date BETWEEN effective_start_date
767: AND effective_end_date;
768: */
769: UPDATE ff_formulas_f
770: SET formula_text = v_new_ele_formula_text
771: WHERE formula_id = v_new_ele_formula_id
772: AND business_group_id = p_ff_bg_id
773: AND g_eff_start_date BETWEEN effective_start_date

Line 783: from ff_formulas_f

779: -- hr_utility.trace('FF '||v_orig_ele_formula_name||' already exists for ele '||p_ff_ele_name);
780:
781: select count(0)
782: into l_count_already
783: from ff_formulas_f
784: where upper(formula_name) like upper('%'||l_placehold_ele_name||'%');
785:
786:
787: hr_utility.set_location('hr_generate_pretax.ins_base_formula',35);

Line 804: INSERT INTO ff_formulas_f ( FORMULA_ID,

800: FROM sys.dual;
801:
802: hr_utility.set_location('hr_generate_pretax.ins_base_formula',40);
803:
804: INSERT INTO ff_formulas_f ( FORMULA_ID,
805: EFFECTIVE_START_DATE,
806: EFFECTIVE_END_DATE,
807: BUSINESS_GROUP_ID,
808: LEGISLATION_CODE,

Line 891: FROM ff_formulas_f FF

887: SELECT FF.formula_text,
888: FF.formula_type_id
889: INTO v_skeleton_formula_text,
890: v_skeleton_formula_type_id
891: FROM ff_formulas_f FF
892: WHERE FF.formula_name = 'PRETAX_CALCULATION_FORMULA'
893: AND FF.business_group_id IS NULL
894: AND FF.legislation_code = 'US'
895: AND g_eff_start_date >= FF.effective_start_date

Line 1085: INSERT INTO ff_formulas_f ( FORMULA_ID,

1081: FROM sys.dual;
1082:
1083: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',40);
1084:
1085: INSERT INTO ff_formulas_f ( FORMULA_ID,
1086: EFFECTIVE_START_DATE,
1087: EFFECTIVE_END_DATE,
1088: BUSINESS_GROUP_ID,
1089: LEGISLATION_CODE,

Line 1134: /* Hitting constraint error FF_FORMULAS_F_UK2 with...

1130:
1131: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');
1132: -- hr_utility.trace(v_new_ele_formula_name);
1133:
1134: /* Hitting constraint error FF_FORMULAS_F_UK2 with...
1135: UPDATE ff_formulas_f
1136: SET formula_name = v_new_ele_formula_name,
1137: formula_text = v_new_ele_formula_text
1138: WHERE formula_id = v_new_ele_formula_id

Line 1135: UPDATE ff_formulas_f

1131: -- hr_utility.trace('existing FF '||v_new_ele_formula_id||' being updated');
1132: -- hr_utility.trace(v_new_ele_formula_name);
1133:
1134: /* Hitting constraint error FF_FORMULAS_F_UK2 with...
1135: UPDATE ff_formulas_f
1136: SET formula_name = v_new_ele_formula_name,
1137: formula_text = v_new_ele_formula_text
1138: WHERE formula_id = v_new_ele_formula_id
1139: AND business_group_id = p_ff_bg_id

Line 1144: UPDATE ff_formulas_f

1140: AND g_eff_start_date BETWEEN effective_start_date
1141: AND effective_end_date;
1142: */
1143: -- So trying without updating ff name...
1144: UPDATE ff_formulas_f
1145: SET formula_text = v_new_ele_formula_text
1146: WHERE formula_id = v_new_ele_formula_id
1147: AND business_group_id = p_ff_bg_id
1148: AND g_eff_start_date BETWEEN effective_start_date

Line 1158: from ff_formulas_f

1154: -- hr_utility.trace('FF '||v_orig_ele_formula_name||' already exists for ele '||p_ff_ele_name);
1155:
1156: select count(0)
1157: into l_count_already
1158: from ff_formulas_f
1159: where upper(formula_name) like upper('%'||l_placehold_ele_name||'%');
1160:
1161: -- hr_utility.trace('Preserving text for '||v_orig_ele_formula_name);
1162:

Line 1178: INSERT INTO ff_formulas_f ( FORMULA_ID,

1174: FROM sys.dual;
1175:
1176: hr_utility.set_location('hr_generate_pretax.ins_calc_formula',100);
1177:
1178: INSERT INTO ff_formulas_f ( FORMULA_ID,
1179: EFFECTIVE_START_DATE,
1180: EFFECTIVE_END_DATE,
1181: BUSINESS_GROUP_ID,
1182: LEGISLATION_CODE,

Line 1567: from ff_formulas_f ff

1563: l_iv_defaults_ff_text := ' default for '||l_placeholder_ele_name||'_PERCENTAGE_ENTRY_VALUE is 0';
1564:
1565: select ff.formula_text
1566: into l_calc_dedn_ff_text
1567: from ff_formulas_f ff
1568: where ff.formula_name = 'PRETAX_PERCENTAGE_FF_TEXT'
1569: and ff.business_group_id is null
1570: and ff.legislation_code = 'US'
1571: and sysdate between ff.effective_start_date

Line 1596: from ff_formulas_f ff

1592: END IF;
1593:
1594: select ff.formula_text
1595: into l_calc_dedn_ff_text
1596: from ff_formulas_f ff
1597: where ff.formula_name = 'PRETAX_PAYROLL_TABLE_FF_TEXT'
1598: and ff.business_group_id is null
1599: and ff.legislation_code = 'US'
1600: and sysdate between ff.effective_start_date

Line 1618: from ff_formulas_f ff

1614: l_iv_defaults_ff_text := l_iv_defaults_ff_text||' default for '||l_placeholder_ele_name||'_COVERAGE_ENTRY_VALUE IS ''NOT ENTERED'' ';
1615:
1616: select ff.formula_text
1617: into l_calc_dedn_ff_text
1618: from ff_formulas_f ff
1619: where ff.formula_name = 'PRETAX_BENEFIT_FF_TEXT'
1620: and ff.business_group_id is null
1621: and ff.legislation_code = 'US'
1622: and sysdate between ff.effective_start_date

Line 1639: from ff_formulas_f ff

1635: l_iv_defaults_ff_text := ' default for '||l_placeholder_ele_name||'_AMOUNT_ENTRY_VALUE IS 0';
1636:
1637: select ff.formula_text
1638: into l_calc_dedn_ff_text
1639: from ff_formulas_f ff
1640: where ff.formula_name = 'PRETAX_FLAT_AMOUNT_FF_TEXT'
1641: and ff.business_group_id is null
1642: and ff.legislation_code = 'US'
1643: and sysdate between ff.effective_start_date

Line 3898: FROM ff_formulas_f FF

3894: hr_utility.set_location('hr_generate_pretax.upgrade_template',15);
3895:
3896: SELECT FF.formula_id
3897: INTO v_skip_formula_id
3898: FROM ff_formulas_f FF
3899: WHERE FF.formula_name = 'CHAINED_SKIP_FORMULA'
3900: AND FF.business_group_id IS NULL
3901: AND FF.legislation_code = g_template_leg_code
3902: AND p_ele_eff_start_date >= FF.effective_start_date

Line 3910: FROM ff_formulas_f FF

3906:
3907: hr_utility.set_location('hr_generate_pretax.upgrade_template',20);
3908: SELECT FF.formula_id
3909: INTO v_skip_formula_id
3910: FROM ff_formulas_f FF
3911: WHERE FF.formula_name = 'THRESHOLD_SKIP_FORMULA'
3912: AND FF.business_group_id IS NULL
3913: AND FF.legislation_code = g_template_leg_code
3914: AND p_ele_eff_start_date >= FF.effective_start_date

Line 3923: FROM ff_formulas_f FF

3919: hr_utility.set_location('hr_generate_pretax.upgrade_template',25);
3920:
3921: SELECT FF.formula_id
3922: INTO v_skip_formula_id
3923: FROM ff_formulas_f FF
3924: WHERE FF.formula_name = 'FREQ_RULE_SKIP_FORMULA'
3925: AND FF.business_group_id IS NULL
3926: AND FF.legislation_code = g_template_leg_code
3927: AND p_ele_eff_start_date >= FF.effective_start_date