eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_DELETE dependencies on BEN_COVERED_DEPENDENTS_F

Line 170: 115.27 16-JUL-2003 jpthomas 3026024 Added delete from ben_covered_dependents_f.

166: 115.25 03-DEC-2002 pmfletch MLS Added delete from per_subjects_taken_tl
167: for MLS
168: 115.26 03-DEC-2002 pmfletch MLS Added delete from per_qualifications_tl
169: for MLS
170: 115.27 16-JUL-2003 jpthomas 3026024 Added delete from ben_covered_dependents_f.
171: Delete the entry in the above table for the
172: contact person whom is getting deleted.
173: 115.29 Sep-2003 mbocutt ex-person security enhancements.
174: Remove refs to per_person_list_changes.

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

2157: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 23601);
2158: end;
2159: --
2160: --Bug# 3026024 Start Here
2161: --Description : Delete the entry in the table ben_covered_dependents_f for the
2162: -- contact person whom is getting deleted.
2163: --
2164: --
2165: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 237);

Line 2168: delete from ben_covered_dependents_f c

2164: --
2165: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 237);
2166: --
2167: begin
2168: delete from ben_covered_dependents_f c
2169: where c.contact_relationship_id in (
2170: select r.contact_relationship_id
2171: from per_contact_relationships r
2172: where r.contact_person_id = p_person_id