APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_JOB_BASKET_ITEMS

Line 265: from irc_job_basket_items

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

Line 393: -- Delete from IRC_JOB_BASKET_ITEMS

389: ,p_object_version_number => rec_per_addr.object_version_number
390: );
391: end loop;
392: --
393: -- Delete from IRC_JOB_BASKET_ITEMS
394: --
395: hr_utility.set_location(l_proc, 80);
396: for rec_jbi in csr_jbi loop
397: irc_job_basket_items_api.delete_job_basket_item

Line 397: irc_job_basket_items_api.delete_job_basket_item

393: -- Delete from IRC_JOB_BASKET_ITEMS
394: --
395: hr_utility.set_location(l_proc, 80);
396: for rec_jbi in csr_jbi loop
397: irc_job_basket_items_api.delete_job_basket_item
398: (p_job_basket_item_id => rec_jbi.job_basket_item_id
399: ,p_object_version_number => rec_jbi.object_version_number
400: );
401: end loop;

Line 591: irc_job_basket_items jbo,

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