APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_QUALIFICATIONS

Line 270: from per_qualifications

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

Line 339: -- Delete from PER_QUALIFICATIONS

335:
336:
337:
338: --
339: -- Delete from PER_QUALIFICATIONS
340: --
341: hr_utility.set_location(l_proc, 20);
342: for rec_per_qual in csr_per_qual loop
343: per_qualifications_api.delete_qualification

Line 343: per_qualifications_api.delete_qualification

339: -- Delete from PER_QUALIFICATIONS
340: --
341: hr_utility.set_location(l_proc, 20);
342: for rec_per_qual in csr_per_qual loop
343: per_qualifications_api.delete_qualification
344: (p_qualification_id => rec_per_qual.qualification_id
345: ,p_object_version_number => rec_per_qual.object_version_number
346: );
347: end loop;

Line 589: per_qualifications qua,

585: irc_search_criteria iscp,
586: irc_search_criteria iscw,
587: per_previous_employers pem,
588: per_establishment_attendances esa,
589: per_qualifications qua,
590: per_competence_elements pce,
591: irc_job_basket_items jbo,
592: per_all_people_f per1,
593: per_all_assignments_f asg,