APPS.HR_ORG_PRE_DELETE dependencies on PER_VACANCIES

Line 336: from per_vacancies x

332: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',14);
333: select '1'
334: into l_test_func
335: from sys.dual where exists ( select 1
336: from per_vacancies x
337: where x.organization_id = p_organization_id);
338: if SQL%ROWCOUNT >0 THEN
339: hr_utility.set_message(801,'HR_7337_ORG_VACANCIES');
340: hr_utility.raise_error;

Line 676: -- Doing check on PER_VACANCIES.

672: null;
673: end;
674: --
675: begin
676: -- Doing check on PER_VACANCIES.
677: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',12);
678: select '1'
679: into l_test_func
680: from sys.dual

Line 682: from PER_VACANCIES x

678: select '1'
679: into l_test_func
680: from sys.dual
681: where exists ( select 1
682: from PER_VACANCIES x
683: where x.ORGANIZATION_ID = p_organization_id);
684: --
685: if SQL%ROWCOUNT >0 THEN
686: hr_utility.set_message(801,'HR_6725_BG_VAC_EXIST');