APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_DOCUMENTS

Line 258: from irc_documents

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

Line 403: -- Delete from IRC_DOCUMENTS

399: --
400: begin
401: hr_utility.set_location('Entering Purge Person Info:'||l_proc, 10);
402: --
403: -- Delete from IRC_DOCUMENTS
404: --
405:
406: for rec_irc_doc in csr_irc_doc loop
407: irc_document_api.delete_document

Line 711: irc_documents ido,

707: NVL (MAX (asg.last_update_date), hr_api.g_sot)
708: )
709: from per_addresses addr,
710: per_phones phn,
711: irc_documents ido,
712: irc_search_criteria iscp,
713: irc_search_criteria iscw,
714: per_previous_employers pem,
715: per_establishment_attendances esa,