DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_CONTRACTS_F

Line 532: -- person on per_contracts_f when

528: --
529: hr_utility.set_location('contracts_check',10);
530: --
531: -- Check that no child records exist for the
532: -- person on per_contracts_f when
533: -- the person is deleted
534: --
535: select null
536: into v_delete_permitted

Line 539: from per_contracts_f

535: select null
536: into v_delete_permitted
537: from sys.dual
538: where not exists(select null
539: from per_contracts_f
540: where person_id = p_person_id);
541: --
542: exception
543: when NO_DATA_FOUND then