232: --
233: cursor csr_unique_check(p_mode varchar2) is
234: select bt.balance_type_id
235: from pay_balance_types bt
236: , per_business_groups_perf bg
237: where ((p_mode = 'BALANCE_NAME'
238: and upper(bt.balance_name) = upper(translate(p_balance_name,'_',' ')))
239: or (p_mode = 'REPORTING_NAME'
240: and upper(bt.reporting_name) = upper(translate(p_reporting_name,'_',' ')))