DBA Data[Home] [Help]

APPS.HR_ORU_INS dependencies on PER_SECURITY_PROFILES

Line 430: from per_security_profiles

426: -- Fix 3565334
427: -- Added cursor csr_sec_profile and variables
428: cursor csr_sec_profile(p_security_profile_id in number) is
429: select view_all_organizations_flag
430: from per_security_profiles
431: where security_profile_id = p_security_profile_id;
432: l_security_profile_id per_security_profiles.security_profile_id%type;
433: l_view_all_orgs per_security_profiles.view_all_organizations_flag%type;
434: -- End Fix 3565334

Line 432: l_security_profile_id per_security_profiles.security_profile_id%type;

428: cursor csr_sec_profile(p_security_profile_id in number) is
429: select view_all_organizations_flag
430: from per_security_profiles
431: where security_profile_id = p_security_profile_id;
432: l_security_profile_id per_security_profiles.security_profile_id%type;
433: l_view_all_orgs per_security_profiles.view_all_organizations_flag%type;
434: -- End Fix 3565334
435: --
436: l_proc varchar2(72) := g_package||'ins';

Line 433: l_view_all_orgs per_security_profiles.view_all_organizations_flag%type;

429: select view_all_organizations_flag
430: from per_security_profiles
431: where security_profile_id = p_security_profile_id;
432: l_security_profile_id per_security_profiles.security_profile_id%type;
433: l_view_all_orgs per_security_profiles.view_all_organizations_flag%type;
434: -- End Fix 3565334
435: --
436: l_proc varchar2(72) := g_package||'ins';
437: --