24: g_bg_context_name varchar2(30) := 'Business Group Information';
25: g_automatic_method varchar2(1) := 'A';
26: --
27: g_EMP_Num_FF_cached boolean := FALSE;
28: g_EMP_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;
29: --
30: g_APL_Num_FF_cached boolean := FALSE;
31: g_APL_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;
32: --
27: g_EMP_Num_FF_cached boolean := FALSE;
28: g_EMP_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;
29: --
30: g_APL_Num_FF_cached boolean := FALSE;
31: g_APL_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;
32: --
33: g_CWK_Num_FF_cached boolean := FALSE;
34: g_CWK_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;
35:
30: g_APL_Num_FF_cached boolean := FALSE;
31: g_APL_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;
32: --
33: g_CWK_Num_FF_cached boolean := FALSE;
34: g_CWK_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;
35:
36: --
37: -- ---------------------------------------------------------------------------+
38: -- Local Procedures
866: ,p_effective_date date)
867: RETURN number IS
868: --
869: l_formula_id number;
870: l_formula_name ff_formulas_f.formula_name%TYPE;
871: e_NoFormula exception;
872: --
873: BEGIN
874: l_formula_id := null;
884: end if;
885: --
886: select ff.formula_id
887: into l_formula_id
888: from ff_formulas_f ff
889: where ff.formula_name = l_formula_name
890: and ff.business_group_id = 0 -- global FF defined in Setup BG
891: -- we ignore the Legislation Code
892: and p_effective_date between ff.effective_start_date and