APPS.PER_ORG_STRUCTURES_PKG dependencies on PER_SECURITY_PROFILES

Line 51: from per_security_profiles psp

47: select psp.view_all_organizations_flag,
48: psp.security_profile_id
49: into p_view_all_orgs,
50: p_security_profile_id
51: from per_security_profiles psp
52: where psp.security_profile_id = fnd_profile.value('PER_SECURITY_PROFILE_ID')
53: and ( psp.business_group_id + 0 = p_business_group_id
54: or psp.business_group_id is null);
55: exception

Line 630: from per_security_profiles sp

626: select null
627: into l_dummy
628: from sys.dual
629: where exists( select 1
630: from per_security_profiles sp
631: where sp.organization_id is not null
632: and ( sp.business_group_id + 0 = p_business_group_id
633: or ( sp.business_group_id is null
634: and p_business_group_id is null))