146: --
147: cursor get_leg_rule(p_leg_code varchar2)
148: is
149: select rule_mode
150: from pay_legislation_rules
151: where rule_type = 'BAL_CATEGORY_MANDATORY'
152: and legislation_code = p_leg_code;
153: --
154: l_rule_mode pay_legislation_rules.rule_mode%type;
150: from pay_legislation_rules
151: where rule_type = 'BAL_CATEGORY_MANDATORY'
152: and legislation_code = p_leg_code;
153: --
154: l_rule_mode pay_legislation_rules.rule_mode%type;
155: --
156: leg_rule_found boolean := FALSE ;
157: begin
158: hr_utility.set_location('Entering '||l_proc, 5);