DBA Data[Home] [Help]

APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_PREVIOUS_EMPLOYERS

Line 280: from per_previous_employers

276: where party_id = p_party_id;
277: --
278: cursor csr_per_prev_empl is
279: select previous_employer_id, object_version_number
280: from per_previous_employers
281: where party_id = p_party_id;
282: --
283: cursor csr_per_comps is
284: select competence_element_id, object_version_number

Line 361: -- Delete from Per_Previous_Employers

357: ,p_object_version_number => rec_per_est_att.object_version_number
358: );
359: end loop;
360: --
361: -- Delete from Per_Previous_Employers
362: -- This deletes data from Per_Previous_jobs an per_previous_job_usages also
363: --
364: hr_utility.set_location(l_proc, 40);
365: for rec_per_prev_empl in csr_per_prev_empl loop

Line 587: per_previous_employers pem,

583: per_phones phn,
584: irc_documents ido,
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,