APPS.HR_PERSON_INTERNAL dependencies on PER_SUBJECTS_TAKEN

Line 3563: -- delete per_qualification and per_subjects_taken records

3559: end;
3560: --
3561: -- End addition for quickhire checklists
3562: --
3563: -- delete per_qualification and per_subjects_taken records
3564: if g_debug then
3565: hr_utility.set_location(l_proc, 210);
3566: end if;
3567: --

Line 3582: delete from per_subjects_taken_tl st

3578: --
3579: if l_count = 1 then
3580: --PMFLETCH Added delete from tl table
3581: --
3582: delete from per_subjects_taken_tl st
3583: where st.subjects_taken_id IN
3584: (select s.subjects_taken_id
3585: from per_subjects_taken s
3586: ,per_qualifications q

Line 3585: from per_subjects_taken s

3581: --
3582: delete from per_subjects_taken_tl st
3583: where st.subjects_taken_id IN
3584: (select s.subjects_taken_id
3585: from per_subjects_taken s
3586: ,per_qualifications q
3587: where q.party_id = l_party_id
3588: and s.qualification_id = q.qualification_id
3589: );

Line 3595: delete from per_subjects_taken s

3591: if g_debug then
3592: hr_utility.set_location(l_proc, 220);
3593: end if;
3594: --
3595: delete from per_subjects_taken s
3596: where s.qualification_id in
3597: (select qualification_id
3598: from per_qualifications
3599: where party_id = l_party_id );

Line 3631: /* delete from per_subjects_taken_tl st

3627: -- Fix for 4490489 ends here
3628: --
3629: --
3630: --PMFLETCH Added delete from tl table
3631: /* delete from per_subjects_taken_tl st
3632: where st.subjects_taken_id IN
3633: (select s.subjects_taken_id
3634: from per_subjects_taken s
3635: ,per_qualifications q

Line 3634: from per_subjects_taken s

3630: --PMFLETCH Added delete from tl table
3631: /* delete from per_subjects_taken_tl st
3632: where st.subjects_taken_id IN
3633: (select s.subjects_taken_id
3634: from per_subjects_taken s
3635: ,per_qualifications q
3636: where q.person_id = P_PERSON_ID
3637: and s.qualification_id = q.qualification_id
3638: );

Line 3644: delete from per_subjects_taken s

3640: if g_debug then
3641: hr_utility.set_location(l_proc, 220);
3642: end if;
3643: --
3644: delete from per_subjects_taken s
3645: where s.qualification_id in
3646: (select qualification_id
3647: from per_qualifications
3648: where person_id = P_PERSON_ID );