DBA Data[Home] [Help]

APPS.HR_ORG_PRE_DELETE dependencies on PAY_PAYROLLS_F

Line 384: from pay_payrolls_f x

380: hr_utility.set_location('hr_org_pre_delete.hr_org_predel_check',16);
381: select '1'
382: into l_test_func
383: from sys.dual where exists ( select 1
384: from pay_payrolls_f x
385: where x.organization_id = p_organization_id);
386: if SQL%ROWCOUNT >0 THEN
387: hr_utility.set_message(801,'HR_7331_ORG_PAYROLLS_EXIST');
388: hr_utility.raise_error;

Line 483: -- Doing check on PAY_PAYROLLS_F.

479: null;
480: end;
481: --
482: begin
483: -- Doing check on PAY_PAYROLLS_F.
484: hr_utility.set_location('hr_org_pre_delete.hr_strong_bg_chk',2);
485: select '1'
486: into l_test_func
487: from sys.dual

Line 489: from PAY_PAYROLLS_F x

485: select '1'
486: into l_test_func
487: from sys.dual
488: where exists ( select 1
489: from PAY_PAYROLLS_F x
490: where x.ORGANIZATION_ID = p_organization_id);
491: --
492: if SQL%ROWCOUNT >0 THEN
493: hr_utility.set_message(801,'HR_6717_BG_PAYROLL_EXIST');