APPS.PER_QH_ACTION dependencies on FF_FORMULAS_F

Line 817: from ff_formulas_f fff

813: l_ff5 varchar2(240);
814: --
815: cursor csr_formula_id(p_name VARCHAR2)is
816: select formula_id
817: from ff_formulas_f fff
818: , ff_formula_types fft
819: where fff.formula_name = p_name
820: and p_effective_date between fff.effective_start_date and fff.effective_end_date
821: and fff.formula_type_id=fft.formula_type_id

Line 824: l_formula_id ff_formulas_f.formula_id%type;

820: and p_effective_date between fff.effective_start_date and fff.effective_end_date
821: and fff.formula_type_id=fft.formula_type_id
822: and fft.formula_type_name='People Management Message';
823: --
824: l_formula_id ff_formulas_f.formula_id%type;
825: l_formula_inputs ff_exec.inputs_t;
826: l_formula_outputs ff_exec.outputs_t;
827: l_index_number NUMBER;
828: --