APPS.HR_ORG_PRE_DELETE dependencies on HR_ORGANIZATION_UNITS
Line 95: -- Do Any rows Exist in HR_ORGANIZATION_UNITS.
91: null;
92: end;
93: --
94: begin 95: -- Do Any rows Exist in HR_ORGANIZATION_UNITS. 96: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
97: ,2);
98: select '1'
99: into l_test_func
Line 102: from HR_ORGANIZATION_UNITS x
98: select '1'
99: into l_test_func
100: from sys.dual
101: where exists ( select 1 102: from HR_ORGANIZATION_UNITS x 103: where x.business_group_id = p_business_group_id
104: and x.organization_id <> p_business_group_id);
105: --
106: if SQL%ROWCOUNT >0 THEN