DBA Data[Home] [Help]

APPS.HR_ORG_PRE_DELETE dependencies on PAY_ELEMENT_LINKS_F

Line 368: from pay_element_links_f x

364: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',16);
365: select '1'
366: into l_test_func
367: from sys.dual where exists ( select 1
368: from pay_element_links_f x
369: where x.organization_id = p_organization_id);
370: if SQL%ROWCOUNT >0 THEN
371: hr_utility.set_message(801,'HR_7330_ORG_LINKS_EXIST');
372: hr_utility.raise_error;

Line 464: -- Doing check on PAY_ELEMENT_LINKS_F.

460: begin
461: --
462:
463: begin
464: -- Doing check on PAY_ELEMENT_LINKS_F.
465: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',1);
466: select '1'
467: into l_test_func
468: from sys.dual

Line 470: from PAY_ELEMENT_LINKS_F x

466: select '1'
467: into l_test_func
468: from sys.dual
469: where exists ( select 1
470: from PAY_ELEMENT_LINKS_F x
471: where x.ORGANIZATION_ID = p_organization_id);
472: --
473: if SQL%ROWCOUNT >0 THEN
474: hr_utility.set_message(801,'HR_6719_BG_ELE_LINK');