APPS.PER_BG_NUMBERING_METHOD_PKG dependencies on FF_FORMULAS_F

Line 28: g_EMP_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;

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: --

Line 31: g_APL_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;

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:

Line 34: g_CWK_Num_FF_ID_cache ff_formulas_f.formula_name%TYPE := null;

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

Line 876: l_formula_name ff_formulas_f.formula_name%TYPE;

872: ,p_effective_date date)
873: RETURN number IS
874: --
875: l_formula_id number;
876: l_formula_name ff_formulas_f.formula_name%TYPE;
877: e_NoFormula exception;
878: --
879: BEGIN
880: l_formula_id := null;

Line 894: from ff_formulas_f ff

890: end if;
891: --
892: select ff.formula_id
893: into l_formula_id
894: from ff_formulas_f ff
895: where ff.formula_name = l_formula_name
896: and ff.business_group_id = 0 -- global FF defined in Setup BG
897: -- we ignore the Legislation Code
898: and p_effective_date between ff.effective_start_date and