APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_ADDRESSES

Line 293: from per_addresses

289: where party_id = p_party_id;
290: --
291: cursor csr_per_addr is
292: select address_id, object_version_number
293: from per_addresses
294: where party_id = p_party_id
295: order by primary_flag, date_from desc;
296: --
297: cursor csr_isc_work is

Line 467: --Delete from Per_Addresses

463: ,p_object_version_number => rec_per_comps.object_version_number
464: );
465: end loop;
466: --
467: --Delete from Per_Addresses
468: --
469: hr_utility.set_location(l_proc, 60);
470: for rec_per_addr in csr_per_addr loop
471: per_add_del.del

Line 709: from per_addresses addr,

705: NVL (MAX (iscp.last_update_date), hr_api.g_sot),
706: MAX (per2.last_update_date),
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,