DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_CONTRACTS_F

Line 531: -- person on per_contracts_f when

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

Line 538: from per_contracts_f

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