APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_ADDRESSES

Line 290: from per_addresses

286: where party_id = p_party_id;
287: --
288: cursor csr_per_addr is
289: select address_id, object_version_number
290: from per_addresses
291: where party_id = p_party_id
292: order by primary_flag;
293: --
294: cursor csr_isc_work is

Line 383: --Delete from Per_Addresses

379: ,p_object_version_number => rec_per_comps.object_version_number
380: );
381: end loop;
382: --
383: --Delete from Per_Addresses
384: --
385: hr_utility.set_location(l_proc, 60);
386: for rec_per_addr in csr_per_addr loop
387: per_add_del.del

Line 582: from per_addresses addr,

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