APPS.HR_ORGANIZATION dependencies on HR_ORGANIZATION_UNITS

Line 77: 70.21 04-MAY-93 TMATHERS changed HR_ORGANIZATION_UNITS

73: unique name check to stop
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

Line 986: FROM hr_organization_units org

982: FROM sys.dual
983: WHERE exists
984: (
985: SELECT 'Name Already Exists'
986: FROM hr_organization_units org
987: WHERE (org.organization_id <> p_organization_id
988: OR p_organization_id IS NULL)
989: AND p_organization_name = org.name
990: AND (org.business_group_id + 0 = p_business_group_id

Line 1072: -- Do Any rows Exist in HR_ORGANIZATION_UNITS.

1068: null;
1069: end;
1070: --
1071: begin
1072: -- Do Any rows Exist in HR_ORGANIZATION_UNITS.
1073: hr_utility.set_location('hr_organization.org_predel_check',2);
1074: select '1'
1075: into l_test_func
1076: from sys.dual

Line 1078: from HR_ORGANIZATION_UNITS x

1074: select '1'
1075: into l_test_func
1076: from sys.dual
1077: where exists ( select 1
1078: from HR_ORGANIZATION_UNITS x
1079: where x.business_group_id = p_business_group_id
1080: and x.organization_id <> p_business_group_id);
1081: --
1082: if SQL%ROWCOUNT >0 THEN