APPS.HR_ORG_PRE_DELETE dependencies on PER_SECURITY_PROFILES

Line 432: from per_security_profiles x

428: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',20);
429: select '1'
430: into l_test_func
431: from sys.dual where exists ( select 1
432: from per_security_profiles x
433: where x.organization_id = p_organization_id);
434: if SQL%ROWCOUNT >0 THEN
435: hr_utility.set_message(801,'HR_7339_ORG_SEC_PROFILE');
436: hr_utility.raise_error;

Line 657: -- Doing check on PER_SECURITY_PROFILES.

653: null;
654: end;
655: --
656: begin
657: -- Doing check on PER_SECURITY_PROFILES.
658: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',11);
659: select '1'
660: into l_test_func
661: from sys.dual

Line 663: from PER_SECURITY_PROFILES x

659: select '1'
660: into l_test_func
661: from sys.dual
662: where exists ( select 1
663: from PER_SECURITY_PROFILES x
664: where x.ORGANIZATION_ID = p_organization_id);
665: --
666: if SQL%ROWCOUNT >0 THEN
667: hr_utility.set_message(801,'HR_6724_BG_SEC_PROF_EXIST');