468: raise;
469: return(currencyCodeIn);
470: end getCurrencyName;
471: function getBusGroupName(busGroupIdIn in integer) return varchar2 as
472: tempName per_business_groups.name%type;
473: begin
474: if(busGroupIdIn is null) then
475: return(null);
476: end if;
475: return(null);
476: end if;
477: select name
478: into tempName
479: from per_business_groups
480: where
481: business_group_id = busGroupIdIn and
482: sysdate >= date_from and
483: (date_to is null or sysdate < date_to);