DBA Data[Home] [Help]

APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_COMPETENCE_ELEMENTS

Line 288: from per_competence_elements

284: where party_id = p_party_id;
285: --
286: cursor csr_per_comps is
287: select competence_element_id, object_version_number
288: from per_competence_elements
289: where party_id = p_party_id;
290: --
291: cursor csr_per_addr is
292: select address_id, object_version_number

Line 457: -- Delete from Per_Competence_Elements

453: );
454: end loop;
455: --
456: -- Api checks for competence_element_id being a parent.
457: -- Delete from Per_Competence_Elements
458: --
459: hr_utility.set_location(l_proc, 50);
460: for rec_per_comps in csr_per_comps loop
461: hr_competence_element_api.delete_competence_element

Line 717: per_competence_elements pce,

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,
721: per_all_people_f per2