DBA Data[Home] [Help]

APPS.HRFASTANSWERS dependencies on FND_PROFILE

Line 162: if (FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') is not null) then

158: 1. Get org hierarchy from BIS Reporting Hierarchy profile option
159: (for customers who have upgraded from BIS 1.2 to BIS 11i)
160: ************************************************************************/
161:
162: if (FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') is not null) then
163:
164: l_str_id := to_number( FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') );
165:
166: -- Check to see if Structure still exists

Line 164: l_str_id := to_number( FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') );

160: ************************************************************************/
161:
162: if (FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') is not null) then
163:
164: l_str_id := to_number( FND_Profile.Value('HR_BIS_REPORTING_HIERARCHY') );
165:
166: -- Check to see if Structure still exists
167: if (l_str_id is not null) then
168:

Line 193: l_enable_sg := fnd_profile.value('ENABLE_SECURITY_GROUPS');

189: ************************************************************************/
190:
191: if (l_str_id is null) then
192:
193: l_enable_sg := fnd_profile.value('ENABLE_SECURITY_GROUPS');
194:
195: if (l_enable_sg = 'N') then
196:
197: -- Not a bureau, i.e. a regular customer

Line 199: l_security_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');

195: if (l_enable_sg = 'N') then
196:
197: -- Not a bureau, i.e. a regular customer
198:
199: l_security_profile_id := fnd_profile.value('PER_SECURITY_PROFILE_ID');
200:
201: open c_sp_non_bureau( l_security_profile_id );
202:
203: fetch c_sp_non_bureau into l_all_org, l_str_id;