APPS.HR_ORG_PRE_DELETE dependencies on PER_PEOPLE_F

Line 75: -- Do Any rows Exist in PER_PEOPLE_F.

71: -- it is a business group and so do all relavant checks for Business group.
72: if p_organization_id = p_business_group_id then
73: begin
74: begin
75: -- Do Any rows Exist in PER_PEOPLE_F.
76: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check'
77: ,1);
78: select '1'
79: into l_test_func

Line 82: from PER_PEOPLE_F x

78: select '1'
79: into l_test_func
80: from sys.dual
81: where exists ( select 1
82: from PER_PEOPLE_F x
83: where x.business_group_id = p_business_group_id);
84: --
85: if SQL%ROWCOUNT >0 THEN
86: hr_utility.set_message(801,'HR_6130_ORG_PEOPLE_EXIST');