APPS.HR_ORGANIZATION_API dependencies on PER_SECURITY_PROFILES

Line 292: from per_security_profiles

288: --
289: -- Added cursor csr_sec_profile
290: cursor csr_sec_profile(p_security_profile_id in number) is
291: select view_all_organizations_flag
292: from per_security_profiles
293: where security_profile_id = p_security_profile_id;
294: --
295: l_proc varchar2(72) := g_package||'create_organization_internal';
296: l_organization_id hr_all_organization_units.organization_id%type;

Line 299: l_security_profile_id per_security_profiles.security_profile_id%type;

295: l_proc varchar2(72) := g_package||'create_organization_internal';
296: l_organization_id hr_all_organization_units.organization_id%type;
297: l_object_version_number hr_all_organization_units.object_version_number%type;
298: l_language_code hr_all_organization_units_tl.language%type;
299: l_security_profile_id per_security_profiles.security_profile_id%type;
300: l_view_all_orgs per_security_profiles.view_all_organizations_flag%type;
301: --
302: BEGIN
303: --

Line 300: l_view_all_orgs per_security_profiles.view_all_organizations_flag%type;

296: l_organization_id hr_all_organization_units.organization_id%type;
297: l_object_version_number hr_all_organization_units.object_version_number%type;
298: l_language_code hr_all_organization_units_tl.language%type;
299: l_security_profile_id per_security_profiles.security_profile_id%type;
300: l_view_all_orgs per_security_profiles.view_all_organizations_flag%type;
301: --
302: BEGIN
303: --
304: hr_utility.set_location('Entering:'|| l_proc, 10);