DBA Data[Home] [Help]

APPS.HR_ORGANIZATION dependencies on PER_PEOPLE_F

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

1049: -- it is a business group and so do all relavant checks for Business group.
1050: if p_organization_id = p_business_group_id then
1051: begin
1052: begin
1053: -- Do Any rows Exist in PER_PEOPLE_F.
1054: hr_utility.set_location('hr_organization.org_predel_check',1);
1055: select '1'
1056: into l_test_func
1057: from sys.dual

Line 1059: from PER_PEOPLE_F x

1055: select '1'
1056: into l_test_func
1057: from sys.dual
1058: where exists ( select 1
1059: from PER_PEOPLE_F x
1060: where x.business_group_id = p_business_group_id);
1061: --
1062: if SQL%ROWCOUNT >0 THEN
1063: hr_utility.set_message(801,'HR_6130_ORG_PEOPLE_EXIST');