1524: p_formula_id number,p_out_name varchar2)
1525: is
1526: select input_value_id,frr.result_rule_type,frr.severity_level
1527: from pay_formula_result_rules_f frr,
1528: pay_status_processing_rules_f spr
1529: where spr.element_type_id= p_ele_type
1530: and spr.formula_id = p_formula_id
1531: and spr.status_processing_rule_id = frr.status_processing_rule_id
1532: and upper(frr.result_name) = upper(p_out_name)
1605: --
1606: -- get formula id
1607: select formula_id
1608: into l_formula_id
1609: from pay_status_processing_rules_f
1610: where element_type_id =p_ele_type
1611: and processing_rule='B'
1612: and p_effdate between effective_start_date and effective_end_date;
1613: