APPS.FII_PMV_UTIL dependencies on PER_SECURITY_PROFILES

Line 314: FROM per_security_profiles

310: IF g_security_profile_id is not null AND g_security_profile_id <> -1 THEN
311:
312: SELECT view_all_organizations_flag, business_group_id
313: INTO l_all_org_flag, l_business_group_id
314: FROM per_security_profiles
315: WHERE security_profile_id = g_security_profile_id;
316:
317: /* Case 1: User has access to all organizations. */
318: IF l_all_org_flag = 'Y' and l_business_group_id is NULL THEN

Line 949: FROM per_security_profiles

945: -- Bug 5527135: Added the condition to also handle g_security_profile_id <> -1
946: IF g_security_profile_id is NOT NULL AND g_security_profile_id <> -1 THEN
947: SELECT view_all_organizations_flag, business_group_id
948: INTO l_all_org_flag, l_business_group_id
949: FROM per_security_profiles
950: WHERE security_profile_id = g_security_profile_id;
951:
952: /* 'MO: Security Profile' is defined with a global view all security profile.*/
953: IF l_all_org_flag = 'Y' and l_business_group_id is NULL THEN

Line 977: FROM per_security_profiles

973: g_security_profile_id := fii_pmv_util.get_sec_profile;
974:
975: SELECT business_group_id
976: INTO l_business_group_id
977: FROM per_security_profiles
978: WHERE security_profile_id = g_security_profile_id;
979:
980: return NVL(l_business_group_id,-1);
981: EXCEPTION