APPS.HR_PERSON_INTERNAL dependencies on PER_SUBJECTS_TAKEN

Line 3510: -- delete per_qualification and per_subjects_taken records

3506: end;
3507: --
3508: -- End addition for quickhire checklists
3509: --
3510: -- delete per_qualification and per_subjects_taken records
3511: if g_debug then
3512: hr_utility.set_location(l_proc, 210);
3513: end if;
3514: --

Line 3529: delete from per_subjects_taken_tl st

3525: --
3526: if l_count = 1 then
3527: --PMFLETCH Added delete from tl table
3528: --
3529: delete from per_subjects_taken_tl st
3530: where st.subjects_taken_id IN
3531: (select s.subjects_taken_id
3532: from per_subjects_taken s
3533: ,per_qualifications q

Line 3532: from per_subjects_taken s

3528: --
3529: delete from per_subjects_taken_tl st
3530: where st.subjects_taken_id IN
3531: (select s.subjects_taken_id
3532: from per_subjects_taken s
3533: ,per_qualifications q
3534: where q.party_id = l_party_id
3535: and s.qualification_id = q.qualification_id
3536: );

Line 3542: delete from per_subjects_taken s

3538: if g_debug then
3539: hr_utility.set_location(l_proc, 220);
3540: end if;
3541: --
3542: delete from per_subjects_taken s
3543: where s.qualification_id in
3544: (select qualification_id
3545: from per_qualifications
3546: where party_id = l_party_id );

Line 3578: /* delete from per_subjects_taken_tl st

3574: -- Fix for 4490489 ends here
3575: --
3576: --
3577: --PMFLETCH Added delete from tl table
3578: /* delete from per_subjects_taken_tl st
3579: where st.subjects_taken_id IN
3580: (select s.subjects_taken_id
3581: from per_subjects_taken s
3582: ,per_qualifications q

Line 3581: from per_subjects_taken s

3577: --PMFLETCH Added delete from tl table
3578: /* delete from per_subjects_taken_tl st
3579: where st.subjects_taken_id IN
3580: (select s.subjects_taken_id
3581: from per_subjects_taken s
3582: ,per_qualifications q
3583: where q.person_id = P_PERSON_ID
3584: and s.qualification_id = q.qualification_id
3585: );

Line 3591: delete from per_subjects_taken s

3587: if g_debug then
3588: hr_utility.set_location(l_proc, 220);
3589: end if;
3590: --
3591: delete from per_subjects_taken s
3592: where s.qualification_id in
3593: (select qualification_id
3594: from per_qualifications
3595: where person_id = P_PERSON_ID );