154: v_id_flex_num number;
155: begin
156: select rule_mode
157: into v_id_flex_num
158: from pay_legislation_rules
159: where legislation_code = v_legislation_code
160: and rule_type = 'S'
161: and exists
162: (select null
214: if category = 'MT' and territory_code is not null then
215: begin
216: select TO_NUMBER(l.rule_mode)
217: into v_id_flex_num
218: from pay_legislation_rules l
219: where l.legislation_code = territory_code
220: and l.rule_type = 'E';
221: c_ext_acct_id := v_id_flex_num;
222: