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 2680: -- delete per_qualification and per_subjects_taken records

2676: end;
2677: --
2678: -- End addition for quickhire checklists
2679: --
2680: -- delete per_qualification and per_subjects_taken records
2681: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 50);
2682: --
2683: begin
2684:

Line 2686: delete from per_subjects_taken_tl st

2682: --
2683: begin
2684:
2685: --PMFLETCH Added delete from tl table
2686: delete from per_subjects_taken_tl st
2687: where st.subjects_taken_id IN ( select s.subjects_taken_id
2688: from per_subjects_taken s
2689: , per_qualifications q
2690: where q.person_id = P_PERSON_ID

Line 2688: from per_subjects_taken s

2684:
2685: --PMFLETCH Added delete from tl table
2686: delete from per_subjects_taken_tl st
2687: where st.subjects_taken_id IN ( select s.subjects_taken_id
2688: from per_subjects_taken s
2689: , per_qualifications q
2690: where q.person_id = P_PERSON_ID
2691: and s.qualification_id = q.qualification_id
2692: );

Line 2697: delete from per_subjects_taken s

2693:
2694: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4698);
2695:
2696:
2697: delete from per_subjects_taken s
2698: where s.qualification_id in ( select qualification_id
2699: from per_qualifications
2700: where person_id = P_PERSON_ID );
2701: