APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_PHONES

Line 311: from per_phones

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

Line 507: -- Delete from PER_PHONES

503: ,p_object_version_number => rec_isc_party.object_version_number
504: );
505: end loop;
506: --
507: -- Delete from PER_PHONES
508: --
509: hr_utility.set_location(l_proc, 110);
510: for rec_phn in csr_phn_party loop
511: hr_phone_api.delete_phone

Line 710: per_phones phn,

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