DBA Data[Home] [Help]

APPS.HR_ORG_PRE_DELETE dependencies on PER_BUDGET_ELEMENTS

Line 416: from per_budget_elements x

412: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',18);
413: select '1'
414: into l_test_func
415: from sys.dual where exists ( select 1
416: from per_budget_elements x
417: where x.organization_id = p_organization_id);
418: if SQL%ROWCOUNT >0 THEN
419: hr_utility.set_message(801,'HR_7335_ORG_BUDGET_ELEMENTS');
420: hr_utility.raise_error;

Line 540: -- Doing check on PER_BUDGET_ELEMENTS.

536: null;
537: end;
538: --
539: begin
540: -- Doing check on PER_BUDGET_ELEMENTS.
541: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',5);
542: select '1'
543: into l_test_func
544: from sys.dual

Line 546: from PER_BUDGET_ELEMENTS x

542: select '1'
543: into l_test_func
544: from sys.dual
545: where exists ( select 1
546: from PER_BUDGET_ELEMENTS x
547: where x.ORGANIZATION_ID = p_organization_id);
548: --
549: if SQL%ROWCOUNT >0 THEN
550: hr_utility.set_message(801,'HR_6720_BG_BUDGET_ELE_EXIST');