2110: IS
2111:
2112: cursor eff_dates is
2113: select max(ff.effective_end_date),min(ff.effective_start_date)
2114: from ff_formulas_f ff
2115: WHERE ff.formula_id = p_formula_id;
2116:
2117: max_eff_end_date date;
2118: min_eff_start_date date;
2142: FUNCTION get_fastformula_name_er(p_formula_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 IS
2143:
2144: cursor eff_dates is
2145: select max(ff.effective_end_date),min(ff.effective_start_date)
2146: from ff_formulas_f ff
2147: WHERE ff.formula_id = p_formula_id;
2148:
2149: cursor c1(p_calculated_date date)
2150: is
2148:
2149: cursor c1(p_calculated_date date)
2150: is
2151: select formula_name
2152: from ff_formulas_f ff
2153: WHERE ff.formula_id = p_formula_id
2154: and p_calculated_date between ff.effective_start_date and ff.effective_end_date;
2155:
2156: l_formula_name varchar2(240);
2196:
2197: FUNCTION get_fastformula_desc_er(p_formula_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 IS
2198: cursor eff_date is
2199: select max(ff.effective_end_date),min(ff.effective_start_date)
2200: from ff_formulas_f ff
2201: WHERE ff.formula_id = p_formula_id;
2202:
2203: cursor c1(p_calculated_date date)
2204: is
2202:
2203: cursor c1(p_calculated_date date)
2204: is
2205: select description
2206: from ff_formulas_f ff
2207: WHERE ff.formula_id = p_formula_id
2208: and p_calculated_date between ff.effective_start_date and ff.effective_end_date;
2209:
2210: l_formula_desc ff_formulas_f.description%type;
2206: from ff_formulas_f ff
2207: WHERE ff.formula_id = p_formula_id
2208: and p_calculated_date between ff.effective_start_date and ff.effective_end_date;
2209:
2210: l_formula_desc ff_formulas_f.description%type;
2211: max_eff_end_date date;
2212: min_eff_start_date date;
2213:
2214: begin