5498: IS
5499: CURSOR csr_formula_name
5500: IS
5501: SELECT ff.formula_name
5502: FROM ff_formulas_f ff
5503: WHERE ff.formula_id = p_formula_id
5504: AND p_effective_date BETWEEN ff.effective_start_date
5505: AND ff.effective_end_date;
5506:
5503: WHERE ff.formula_id = p_formula_id
5504: AND p_effective_date BETWEEN ff.effective_start_date
5505: AND ff.effective_end_date;
5506:
5507: l_formula_name ff_formulas_f.formula_name%TYPE;
5508: BEGIN
5509:
5510: OPEN csr_formula_name;
5511: FETCH csr_formula_name INTO l_formula_name;