444: -- the Setup Business group.
445: --
446: begin
447:
448: if ( fnd_global.user_id = -1 ) then
449: return(null);
450: else
451: return(fnd_profile.value('PER_BUSINESS_GROUP_ID'));
452: end if;
2154:
2155: --
2156: -- bug2372279
2157: --
2158: -- Using fnd_global.per_security_profile_id for performance
2159: -- reasons. hr_security.get_security_profile should probably
2160: -- be used as it looks like reporting users are getting an
2161: -- unrestricted bg view but will address this later as a
2162: -- separate pre-existing issue.
2160: -- be used as it looks like reporting users are getting an
2161: -- unrestricted bg view but will address this later as a
2162: -- separate pre-existing issue.
2163: --
2164: if ( fnd_global.user_id = -1
2165: or fnd_global.per_security_profile_id is null )
2166: then
2167: return 'Y' ;
2168: else
2161: -- unrestricted bg view but will address this later as a
2162: -- separate pre-existing issue.
2163: --
2164: if ( fnd_global.user_id = -1
2165: or fnd_global.per_security_profile_id is null )
2166: then
2167: return 'Y' ;
2168: else
2169: return( fnd_profile.value('HR_CROSS_BUSINESS_GROUP') );