38: BEGIN
39: l_Security_Profile_ID:=fnd_profile.value('XLA_MO_SECURITY_PROFILE_LEVEL');
40: SELECT view_all_organizations_flag
41: INTO l_Not_Secured_Flag
42: FROM per_security_profiles prof
43: WHERE security_profile_id = l_Security_Profile_ID;
44: END;
45:
46: IF l_Not_Secured_Flag = 'Y' THEN
223: IF l_Security_Profile_ID IS NOT NULL THEN
224: BEGIN
225: SELECT view_all_organizations_flag
226: INTO l_Not_Secured_Flag
227: FROM per_security_profiles prof
228: WHERE security_profile_id = l_Security_Profile_ID;
229: IF l_Not_Secured_Flag = 'Y' THEN
230: SELECT 1
231: INTO l_Return_Value