APPS.HR_PERSON_INTERNAL dependencies on PER_QUALIFICATIONS

Line 3533: ,per_qualifications q

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: );
3537: --

Line 3545: from per_qualifications

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 );
3547: --
3548: if g_debug then
3549: hr_utility.set_location(l_proc, 230);

Line 3552: delete from per_qualifications_tl qt

3548: if g_debug then
3549: hr_utility.set_location(l_proc, 230);
3550: end if;
3551: --PMFLETCH Added delete from tl table
3552: delete from per_qualifications_tl qt
3553: where qt.qualification_id in
3554: (select q.qualification_id
3555: from per_qualifications q
3556: where q.party_id = l_party_id);

Line 3555: from per_qualifications q

3551: --PMFLETCH Added delete from tl table
3552: delete from per_qualifications_tl qt
3553: where qt.qualification_id in
3554: (select q.qualification_id
3555: from per_qualifications q
3556: where q.party_id = l_party_id);
3557: --
3558: if g_debug then
3559: hr_utility.set_location(l_proc, 240);

Line 3562: delete from per_qualifications q

3558: if g_debug then
3559: hr_utility.set_location(l_proc, 240);
3560: end if;
3561: --
3562: delete from per_qualifications q
3563: where q.party_id = l_party_id;
3564: --
3565: end if;
3566: --

Line 3582: ,per_qualifications q

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: );
3586: --

Line 3594: from per_qualifications

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 );
3596: --
3597: if g_debug then
3598: hr_utility.set_location(l_proc, 230);

Line 3601: delete from per_qualifications_tl qt

3597: if g_debug then
3598: hr_utility.set_location(l_proc, 230);
3599: end if;
3600: --PMFLETCH Added delete from tl table
3601: delete from per_qualifications_tl qt
3602: where qt.qualification_id in
3603: (select q.qualification_id
3604: from per_qualifications q
3605: where q.person_id = P_PERSON_ID);

Line 3604: from per_qualifications q

3600: --PMFLETCH Added delete from tl table
3601: delete from per_qualifications_tl qt
3602: where qt.qualification_id in
3603: (select q.qualification_id
3604: from per_qualifications q
3605: where q.person_id = P_PERSON_ID);
3606: --
3607: if g_debug then
3608: hr_utility.set_location(l_proc, 240);

Line 3611: delete from per_qualifications q

3607: if g_debug then
3608: hr_utility.set_location(l_proc, 240);
3609: end if;
3610: --
3611: delete from per_qualifications q
3612: where q.person_id = P_PERSON_ID;
3613: --
3614: exception
3615: when NO_DATA_FOUND then