APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_DOCUMENTS

Line 255: from irc_documents

251: --
252:
253: cursor csr_irc_doc is
254: select document_id, object_version_number , party_id,end_date,type,person_id
255: from irc_documents
256: where party_id = p_party_id;
257: --
258: cursor csr_irc_notif is
259: select notification_preference_id, object_version_number

Line 319: -- Delete from IRC_DOCUMENTS

315: --
316: begin
317: hr_utility.set_location('Entering Purge Person Info:'||l_proc, 10);
318: --
319: -- Delete from IRC_DOCUMENTS
320: --
321:
322: for rec_irc_doc in csr_irc_doc loop
323: irc_document_api.delete_document

Line 584: irc_documents ido,

580: NVL (MAX (asg.last_update_date), hr_api.g_sot)
581: )
582: from per_addresses addr,
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,