DBA Data[Home] [Help]

APPS.HR_ORGANIZATION dependencies on FND_ORACLE_USERID

Line 578: -- fnd_oracle_userid f1r an oracle_username with oracle_id = 900

574: if l_install_mode = 'N' then
575: --
576: -- Set the secure_oracle_username for the View All security profile to the
577: -- Oracle ID for the APPS account. This can be derived by looking in
578: -- fnd_oracle_userid f1r an oracle_username with oracle_id = 900
579: --
580: hr_utility.set_location('hr_organization.insert_bus_grp_details',8);
581: INSERT INTO per_security_profiles
582: (security_profile_id

Line 631: fnd_oracle_userid o

627: ,'N'
628: ,'S'
629: ,'S'
630: FROM hr_all_organization_units hou,
631: fnd_oracle_userid o
632: WHERE hou.organization_id = p_organization_id
633: AND o.oracle_id = 900;
634: --
635: if SQL%ROWCOUNT = 0 then