DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_QUALIFICATIONS_TL

Line 168: 115.26 03-DEC-2002 pmfletch MLS Added delete from per_qualifications_tl

164: the WHENEVER OSERROR EXIT FAILURE
165: ROLLBACK
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.

Line 2705: delete from per_qualifications_tl qt

2701:
2702: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4699);
2703:
2704: --PMFLETCH Added delete from tl table
2705: delete from per_qualifications_tl qt
2706: where qt.qualification_id in ( select q.qualification_id
2707: from per_qualifications q
2708: where q.person_id = P_PERSON_ID
2709: );