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