DBA Data[Home] [Help]

APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_COMPETENCE_ELEMENTS

Line 285: from per_competence_elements

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

Line 373: -- Delete from Per_Competence_Elements

369: );
370: end loop;
371: --
372: -- Api checks for competence_element_id being a parent.
373: -- Delete from Per_Competence_Elements
374: --
375: hr_utility.set_location(l_proc, 50);
376: for rec_per_comps in csr_per_comps loop
377: hr_competence_element_api.delete_competence_element

Line 590: per_competence_elements pce,

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