APPS.BE_CALL_FF_PKG dependencies on FF_FORMULAS_F

Line 25: FROM ff_formulas_f

21: CURSOR csr_formula_details
22: (p_session_date DATE
23: ,p_formula_name VARCHAR2) IS
24: SELECT formula_id, effective_start_date
25: FROM ff_formulas_f
26: WHERE formula_name = p_formula_name
27: AND legislation_code = 'BE'
28: AND p_session_date BETWEEN effective_start_date
29: AND effective_end_date;

Line 137: l_formula_id ff_formulas_f.formula_id%TYPE;

133: --
134: --
135: -- Local variables.
136: --
137: l_formula_id ff_formulas_f.formula_id%TYPE;
138: l_effective_start_date ff_formulas_f.effective_start_date%TYPE;
139: l_bg_currency_code VARCHAR2(30);
140: l_inputs ff_exec.inputs_t;
141: l_outputs ff_exec.outputs_t;

Line 138: l_effective_start_date ff_formulas_f.effective_start_date%TYPE;

134: --
135: -- Local variables.
136: --
137: l_formula_id ff_formulas_f.formula_id%TYPE;
138: l_effective_start_date ff_formulas_f.effective_start_date%TYPE;
139: l_bg_currency_code VARCHAR2(30);
140: l_inputs ff_exec.inputs_t;
141: l_outputs ff_exec.outputs_t;
142: wrong_input_params exception;

Line 263: l_formula_id ff_formulas_f.formula_id%type;

259: --
260: --
261: -- Local variables.
262: --
263: l_formula_id ff_formulas_f.formula_id%type;
264: l_effective_start_date ff_formulas_f.effective_start_date%type;
265: l_inputs ff_exec.inputs_t;
266: l_outputs ff_exec.outputs_t;
267: l_return_value VARCHAR(240) := p_national_identifier;

Line 264: l_effective_start_date ff_formulas_f.effective_start_date%type;

260: --
261: -- Local variables.
262: --
263: l_formula_id ff_formulas_f.formula_id%type;
264: l_effective_start_date ff_formulas_f.effective_start_date%type;
265: l_inputs ff_exec.inputs_t;
266: l_outputs ff_exec.outputs_t;
267: l_return_value VARCHAR(240) := p_national_identifier;
268: l_invalid_mesg VARCHAR(240);