APPS.PER_QH_ACTION dependencies on FF_FORMULAS_F

Line 792: from ff_formulas_f fff

788: l_ff5 varchar2(240);
789: --
790: cursor csr_formula_id(p_name VARCHAR2)is
791: select formula_id
792: from ff_formulas_f fff
793: , ff_formula_types fft
794: where fff.formula_name = p_name
795: and p_effective_date between fff.effective_start_date and fff.effective_end_date
796: and fff.formula_type_id=fft.formula_type_id

Line 799: l_formula_id ff_formulas_f.formula_id%type;

795: and p_effective_date between fff.effective_start_date and fff.effective_end_date
796: and fff.formula_type_id=fft.formula_type_id
797: and fft.formula_type_name='People Management Message';
798: --
799: l_formula_id ff_formulas_f.formula_id%type;
800: l_formula_inputs ff_exec.inputs_t;
801: l_formula_outputs ff_exec.outputs_t;
802: l_index_number NUMBER;
803: --