APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_JOB_BASKET_ITEMS

Line 268: from irc_job_basket_items

264: where party_id = p_party_id;
265: --
266: cursor csr_jbi is
267: select job_basket_item_id, object_version_number
268: from irc_job_basket_items
269: where party_id = p_party_id;
270: --
271: cursor csr_per_qual is
272: select qualification_id, object_version_number

Line 477: -- Delete from IRC_JOB_BASKET_ITEMS

473: ,p_object_version_number => rec_per_addr.object_version_number
474: );
475: end loop;
476: --
477: -- Delete from IRC_JOB_BASKET_ITEMS
478: --
479: hr_utility.set_location(l_proc, 80);
480: for rec_jbi in csr_jbi loop
481: irc_job_basket_items_api.delete_job_basket_item

Line 481: irc_job_basket_items_api.delete_job_basket_item

477: -- Delete from IRC_JOB_BASKET_ITEMS
478: --
479: hr_utility.set_location(l_proc, 80);
480: for rec_jbi in csr_jbi loop
481: irc_job_basket_items_api.delete_job_basket_item
482: (p_job_basket_item_id => rec_jbi.job_basket_item_id
483: ,p_object_version_number => rec_jbi.object_version_number
484: );
485: end loop;

Line 718: irc_job_basket_items jbo,

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
722: where per1.person_id=p_person_id