APPS.HR_PERSON_INTERNAL dependencies on PER_QUALIFICATIONS

Line 3586: ,per_qualifications q

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

Line 3598: from per_qualifications

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 );
3600: --
3601: if g_debug then
3602: hr_utility.set_location(l_proc, 230);

Line 3605: delete from per_qualifications_tl qt

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

Line 3608: from per_qualifications q

3604: --PMFLETCH Added delete from tl table
3605: delete from per_qualifications_tl qt
3606: where qt.qualification_id in
3607: (select q.qualification_id
3608: from per_qualifications q
3609: where q.party_id = l_party_id);
3610: --
3611: if g_debug then
3612: hr_utility.set_location(l_proc, 240);

Line 3615: delete from per_qualifications q

3611: if g_debug then
3612: hr_utility.set_location(l_proc, 240);
3613: end if;
3614: --
3615: delete from per_qualifications q
3616: where q.party_id = l_party_id;
3617: --
3618: end if;
3619: --

Line 3635: ,per_qualifications q

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

Line 3647: from per_qualifications

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 );
3649: --
3650: if g_debug then
3651: hr_utility.set_location(l_proc, 230);

Line 3654: delete from per_qualifications_tl qt

3650: if g_debug then
3651: hr_utility.set_location(l_proc, 230);
3652: end if;
3653: --PMFLETCH Added delete from tl table
3654: delete from per_qualifications_tl qt
3655: where qt.qualification_id in
3656: (select q.qualification_id
3657: from per_qualifications q
3658: where q.person_id = P_PERSON_ID);

Line 3657: from per_qualifications q

3653: --PMFLETCH Added delete from tl table
3654: delete from per_qualifications_tl qt
3655: where qt.qualification_id in
3656: (select q.qualification_id
3657: from per_qualifications q
3658: where q.person_id = P_PERSON_ID);
3659: --
3660: if g_debug then
3661: hr_utility.set_location(l_proc, 240);

Line 3664: delete from per_qualifications q

3660: if g_debug then
3661: hr_utility.set_location(l_proc, 240);
3662: end if;
3663: --
3664: delete from per_qualifications q
3665: where q.person_id = P_PERSON_ID;
3666: --
3667: exception
3668: when NO_DATA_FOUND then