APPS.HR_PERSON_DELETE dependencies on PER_SUBJECTS_TAKEN

Line 166: 115.25 03-DEC-2002 pmfletch MLS Added delete from per_subjects_taken_tl

162: orphan rows.
163: 115.24 02-DEC-2002 eumenyio added the nocopy compiler and also
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.

Line 2609: -- delete per_qualification and per_subjects_taken records

2605: end;
2606: --
2607: -- End addition for quickhire checklists
2608: --
2609: -- delete per_qualification and per_subjects_taken records
2610: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 50);
2611: --
2612: begin
2613:

Line 2615: delete from per_subjects_taken_tl st

2611: --
2612: begin
2613:
2614: --PMFLETCH Added delete from tl table
2615: delete from per_subjects_taken_tl st
2616: where st.subjects_taken_id IN ( select s.subjects_taken_id
2617: from per_subjects_taken s
2618: , per_qualifications q
2619: where q.person_id = P_PERSON_ID

Line 2617: from per_subjects_taken s

2613:
2614: --PMFLETCH Added delete from tl table
2615: delete from per_subjects_taken_tl st
2616: where st.subjects_taken_id IN ( select s.subjects_taken_id
2617: from per_subjects_taken s
2618: , per_qualifications q
2619: where q.person_id = P_PERSON_ID
2620: and s.qualification_id = q.qualification_id
2621: );

Line 2626: delete from per_subjects_taken s

2622:
2623: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4698);
2624:
2625:
2626: delete from per_subjects_taken s
2627: where s.qualification_id in ( select qualification_id
2628: from per_qualifications
2629: where person_id = P_PERSON_ID );
2630: