APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_PHONES

Line 308: from per_phones

304: and object_type = 'PERSON';
305: --
306: cursor csr_phn_party is
307: select phone_id, object_version_number
308: from per_phones
309: where party_id = p_party_id;
310: --
311: cursor csr_ivc_cons is
312: select vacancy_consideration_id, object_version_number

Line 423: -- Delete from PER_PHONES

419: ,p_object_version_number => rec_isc_party.object_version_number
420: );
421: end loop;
422: --
423: -- Delete from PER_PHONES
424: --
425: hr_utility.set_location(l_proc, 110);
426: for rec_phn in csr_phn_party loop
427: hr_phone_api.delete_phone

Line 583: per_phones phn,

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,
587: per_previous_employers pem,