Line 652: cursor c_rule_type(p_rule_id ff_formulas_f.formula_id%type) is
648: )
649: return varchar2 IS
650:
651: 652: cursor c_rule_type(p_rule_id ff_formulas_f.formula_id%type) is 653: select formula_type_id
654: from ff_formulas_f
655: where formula_id = p_rule_id
656: and p_effective_date
Line 654: from ff_formulas_f
650:
651:
652: cursor c_rule_type(p_rule_id ff_formulas_f.formula_id%type) is
653: select formula_type_id 654: from ff_formulas_f 655: where formula_id = p_rule_id
656: and p_effective_date
657: between effective_start_date
658: and effective_end_date;