APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_VACANCY_CONSIDERATIONS

Line 316: from irc_vacancy_considerations

312: where party_id = p_party_id;
313: --
314: cursor csr_ivc_cons is
315: select vacancy_consideration_id, object_version_number
316: from irc_vacancy_considerations
317: where party_id = p_party_id;
318: --
319:
320: -- For IRC_INTERVIEW_DETAILS

Line 517: -- Delete from IRC_VACANCY_CONSIDERATIONS

513: ,p_object_version_number => rec_phn.object_version_number
514: );
515: end loop;
516: --
517: -- Delete from IRC_VACANCY_CONSIDERATIONS
518: --
519: hr_utility.set_location(l_proc, 112);
520: for rec_ivc in csr_ivc_cons loop
521: irc_vacancy_considerations_api.delete_vacancy_consideration

Line 521: irc_vacancy_considerations_api.delete_vacancy_consideration

517: -- Delete from IRC_VACANCY_CONSIDERATIONS
518: --
519: hr_utility.set_location(l_proc, 112);
520: for rec_ivc in csr_ivc_cons loop
521: irc_vacancy_considerations_api.delete_vacancy_consideration
522: (p_vacancy_consideration_id => rec_ivc.vacancy_consideration_id
523: ,p_object_version_number => rec_ivc.object_version_number
524: );
525: end loop;