APPS.HR_ORGANIZATION dependencies on HR_ALL_ORGANIZATION_UNITS

Line 78: to HR_ALL_ORGANIZATION_UNITS in

74: TOO_MANY_ROWS exception firing.
75: When a BG and an org in the current
76: BG have the same name.
77: 70.21 04-MAY-93 TMATHERS changed HR_ORGANIZATION_UNITS
78: to HR_ALL_ORGANIZATION_UNITS in
79: unique name check
80: 70.22 06-MAY-93 SZWILLIA Changed above back as security does
81: not apply in packages.(Always created
82: in the base user).

Line 117: 110.2 19-AUG-97 DKerr Check hr_all_organization_units rather

113: 70.35 11-Sep-95 SDesai Check that the organization is not a
114: beneficiary (org_predel_check).
115: 110.1 05-aug-97 mstewart Removed reference to now obsolete
116: secure_oracle_username column
117: 110.2 19-AUG-97 DKerr Check hr_all_organization_units rather
118: than view when inserting sec. profile.
119: 110.3 19-SEP-97 DKerr Ensure that the security profile id
120: for the setup business group is 0.
121: Removed obsolete code from earlier

Line 412: l_security_group_name hr_all_organization_units.name%TYPE;

408: l_dummy VARCHAR2(1);
409: l_disability_id_flex_num NUMBER;
410: l_disability_acc_id_flex_num NUMBER;
411: l_osha_id_flex_num NUMBER;
412: l_security_group_name hr_all_organization_units.name%TYPE;
413: l_security_group_id NUMBER;
414: --
415: l_system_person_type VARCHAR2(30);
416: l_system_person_type_old VARCHAR2(30) := ' ';

Line 630: FROM hr_all_organization_units hou,

626: ,'NONE'
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: --

Line 696: FROM hr_all_organization_units hou

692: ,p_last_updated_by
693: ,p_last_update_login
694: ,p_created_by
695: ,p_creation_date
696: FROM hr_all_organization_units hou
697: WHERE hou.organization_id = p_organization_id;
698: --
699: --
700: -- Bug Number: 3303179: Used l_ow_count instead of using SQL%ROWCOUNT after the hr_utility call.