APPS.HR_PERSON_INTERNAL dependencies on BEN_COVERED_DEPENDENTS_F

Line 2874: --Description : Delete the entry in the table ben_covered_dependents_f for the

2870: end if;
2871: end;
2872: --
2873: --Bug# 3026024 Start Here
2874: --Description : Delete the entry in the table ben_covered_dependents_f for the
2875: -- contact person whom is getting deleted.
2876: --
2877: --
2878: if g_debug then

Line 2884: delete from ben_covered_dependents_f c

2880: end if;
2881: --
2882: begin
2883: --
2884: delete from ben_covered_dependents_f c
2885: where c.contact_relationship_id in
2886: (select r.contact_relationship_id
2887: from per_contact_relationships r
2888: where r.contact_person_id = p_person_id