APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_QUALIFICATIONS

Line 273: from per_qualifications

269: where party_id = p_party_id;
270: --
271: cursor csr_per_qual is
272: select qualification_id, object_version_number
273: from per_qualifications
274: where party_id = p_party_id;
275: --
276: cursor csr_per_est_att is
277: select attendance_id, object_version_number

Line 423: -- Delete from PER_QUALIFICATIONS

419:
420:
421:
422: --
423: -- Delete from PER_QUALIFICATIONS
424: --
425: hr_utility.set_location(l_proc, 20);
426: for rec_per_qual in csr_per_qual loop
427: per_qualifications_api.delete_qualification

Line 427: per_qualifications_api.delete_qualification

423: -- Delete from PER_QUALIFICATIONS
424: --
425: hr_utility.set_location(l_proc, 20);
426: for rec_per_qual in csr_per_qual loop
427: per_qualifications_api.delete_qualification
428: (p_qualification_id => rec_per_qual.qualification_id
429: ,p_object_version_number => rec_per_qual.object_version_number
430: );
431: end loop;

Line 716: per_qualifications qua,

712: irc_search_criteria iscp,
713: irc_search_criteria iscw,
714: per_previous_employers pem,
715: per_establishment_attendances esa,
716: per_qualifications qua,
717: per_competence_elements pce,
718: irc_job_basket_items jbo,
719: per_all_people_f per1,
720: per_all_assignments_f asg,