Line 1965: select fnd_number.canonical_to_number(lookup_code)
1961: hr_utility.set_location('pay_db_pay_setup.create_balance_classification',3);
1962: end if;
1963: --
1964: -- Convert Add or Subtract to a number 1965: select fnd_number.canonical_to_number(lookup_code) 1966: into v_scale
1967: from hr_lookups
1968: where lookup_type = 'ADD_SUBTRACT'
1969: and upper(meaning) = upper(p_scale);