APPS.HR_US_GARN_GEN dependencies on FF_FORMULAS_F

Line 852: FROM ff_formulas_f FF

848: SELECT FF.formula_text,
849: FF.formula_type_id
850: INTO v_skeleton_formula_text,
851: v_skeleton_formula_type_id
852: FROM ff_formulas_f FF
853: WHERE FF.formula_name = 'BALANCE_SETUP_FORMULA'
854: AND FF.business_group_id IS NULL
855: AND FF.legislation_code = 'US'
856: AND g_eff_start_date >= FF.effective_start_date

Line 901: INSERT INTO ff_formulas_f (

897: --
898: -- Insert the new formula into current business group:
899: --
900: hr_utility.set_location('hr_us_garn_gen.ins_formula',40);
901: INSERT INTO ff_formulas_f (
902: FORMULA_ID,
903: EFFECTIVE_START_DATE,
904: EFFECTIVE_END_DATE,
905: BUSINESS_GROUP_ID,

Line 952: UPDATE ff_formulas_f

948: -- dbms_output.put_line(v_new_ele_formula_name);
949:
950: hr_utility.set_location('hr_us_garn_gen.ins_formula',70);
951:
952: UPDATE ff_formulas_f
953: SET formula_text = v_new_ele_formula_text
954: WHERE formula_id = v_new_ele_formula_id
955: AND business_group_id+0 = p_ff_bg_id
956: AND g_eff_start_date BETWEEN effective_start_date

Line 966: from ff_formulas_f fff, ff_formula_types ffft

962: hr_utility.trace('FF '||v_orig_ele_formula_name||' already exists for ele '||p_ff_ele_name);
963:
964: select count(0)
965: into l_count_already
966: from ff_formulas_f fff, ff_formula_types ffft
967: where (upper(formula_name) like upper('OLD%_'||v_orig_ele_formula_name) or
968: upper(formula_name) like upper(v_orig_ele_formula_name) or
969: upper(formula_name) like upper('%'||v_orig_ele_formula_name)||'_EXP' or
970: upper(formula_name) like upper('%'||v_orig_ele_formula_name)||'_OLD%' )

Line 994: INSERT INTO ff_formulas_f ( FORMULA_ID,

990: FROM sys.dual;
991:
992: hr_utility.set_location('hr_us_garn_gen.ins_formula',40);
993:
994: INSERT INTO ff_formulas_f ( FORMULA_ID,
995: EFFECTIVE_START_DATE,
996: EFFECTIVE_END_DATE,
997: BUSINESS_GROUP_ID,
998: LEGISLATION_CODE,

Line 1069: FROM ff_formulas_f FF

1065: -- Need skip rule formula
1066: begin
1067: SELECT FF.formula_id
1068: INTO g_skip_formula_id
1069: FROM ff_formulas_f FF
1070: WHERE FF.formula_name = 'WAT_SKIP'
1071: AND FF.business_group_id IS NULL
1072: AND legislation_code = 'US'
1073: AND p_ele_eff_start_date >= FF.effective_start_date

Line 2488: FROM ff_formulas_f

2484: begin
2485:
2486: SELECT formula_id
2487: INTO v_calc_formula_id
2488: FROM ff_formulas_f
2489: WHERE formula_name = garn_pay_formula(i)
2490: AND g_eff_start_date between effective_start_date
2491: and effective_end_date
2492: AND nvl(business_group_id, p_bg_id) + 0 = p_bg_id

Line 5025: FROM pay_status_processing_rules_f spr, ff_formulas_f ff

5021:
5022:
5023: CURSOR get_formulae(l_ele_id in number) IS
5024: SELECT distinct ff.formula_id
5025: FROM pay_status_processing_rules_f spr, ff_formulas_f ff
5026: WHERE spr.element_type_id = l_ele_id
5027: AND ff.formula_id = spr.formula_id
5028: AND ff.business_group_id + 0 = p_business_group_id
5029: AND ff.legislation_code IS NULL;

Line 5033: FROM ff_formulas_f ff

5029: AND ff.legislation_code IS NULL;
5030:
5031: CURSOR get_old_formulae(l_ele_name in varchar2) IS
5032: SELECT distinct ff.formula_id
5033: FROM ff_formulas_f ff
5034: WHERE ff.formula_name like upper('OLD%'||p_ele_name||'_BALANCE_SETUP_FORMULA%')
5035: AND ff.business_group_id + 0 = p_business_group_id;
5036:
5037: CURSOR get_spr(l_ele_id in number) IS

Line 5245: -- FF_FORMULAS_F

5241:
5242: IF assoc_eles(i) IS NOT NULL THEN
5243:
5244: -- Get formula_ids to delete from various tables:
5245: -- FF_FORMULAS_F
5246: -- FF_FDI_USAGES_F
5247: -- FF_COMPILED_INFO_F
5248: --
5249: OPEN get_formulae(assoc_eles(i));

Line 5257: DELETE FROM ff_formulas_f

5253: EXIT WHEN get_formulae%NOTFOUND;
5254:
5255: begin
5256:
5257: DELETE FROM ff_formulas_f
5258: WHERE formula_id = v_ff_id;
5259:
5260: exception when NO_DATA_FOUND then
5261: null;

Line 5318: DELETE FROM ff_formulas_f

5314: EXIT WHEN get_old_formulae%NOTFOUND;
5315:
5316: begin
5317:
5318: DELETE FROM ff_formulas_f
5319: WHERE formula_id = v_ff_id;
5320:
5321: exception when NO_DATA_FOUND then
5322: null;