279: where party_id = p_party_id;
280: --
281: cursor csr_per_prev_empl is
282: select previous_employer_id, object_version_number
283: from per_previous_employers
284: where party_id = p_party_id;
285: --
286: cursor csr_per_comps is
287: select competence_element_id, object_version_number
441: ,p_object_version_number => rec_per_est_att.object_version_number
442: );
443: end loop;
444: --
445: -- Delete from Per_Previous_Employers
446: -- This deletes data from Per_Previous_jobs an per_previous_job_usages also
447: --
448: hr_utility.set_location(l_proc, 40);
449: for rec_per_prev_empl in csr_per_prev_empl loop
710: per_phones phn,
711: irc_documents ido,
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,