APPS.FII_AR_UTIL_PKG dependencies on PER_SECURITY_PROFILES

Line 650: FROM per_security_profiles

646:
647: IF g_security_profile_id is NOT NULL AND g_security_profile_id <> -1 THEN
648: SELECT view_all_organizations_flag, business_group_id
649: INTO l_all_org_flag, l_business_group_id
650: FROM per_security_profiles
651: WHERE security_profile_id = g_security_profile_id;
652:
653: /* 'MO: Security Profile' is defined with a global view all security profile.*/
654: IF l_all_org_flag = 'Y' and l_business_group_id is NULL THEN

Line 677: FROM per_security_profiles

673: g_security_profile_id := fii_ar_util_pkg.get_sec_profile;
674:
675: SELECT business_group_id
676: INTO l_business_group_id
677: FROM per_security_profiles
678: WHERE security_profile_id = g_security_profile_id;
679:
680: return NVL(l_business_group_id,-1);
681: EXCEPTION

Line 1082: FROM per_security_profiles

1078:
1079:
1080: SELECT view_all_organizations_flag, business_group_id
1081: INTO l_all_org_flag, l_business_group_id
1082: FROM per_security_profiles
1083: WHERE security_profile_id = g_security_profile_id;
1084:
1085: IF g_org_id = -111 THEN
1086: l_org_specific_where := NULL;