APPS.PER_HRTCA_MERGE dependencies on PER_ADDRESSES

Line 85: from per_addresses

81: l_events c_events%rowtype;
82: --
83: cursor c_addresses is
84: select *
85: from per_addresses
86: where person_id = p_rec.person_id;
87: --
88: l_addresses c_addresses%rowtype;
89: --

Line 213: update per_addresses

209: p_address_id => l_addresses.address_id,
210: p_party_id => p_rec.party_id,
211: p_object_version_number => l_addresses.object_version_number);
212: */
213: update per_addresses
214: set party_id = p_rec.party_id
215: where address_id = l_addresses.address_id;
216: --
217: end loop;

Line 1248: update PER_ADDRESSES

1244: **
1245: ** For performance reasons just use direct SQL and not the APIs
1246: */
1247: begin
1248: update PER_ADDRESSES
1249: set party_id = null
1250: where party_id = p_party_id;
1251: exception
1252: when no_data_found then

Line 1368: from per_addresses addr,

1364: t_eve_party_id g_party_id_type;
1365: --
1366: cursor c_addresses is
1367: select addr.party_id
1368: from per_addresses addr,
1369: hr_tca_party_unmerge punm
1370: where addr.party_id = punm.party_id
1371: and punm.status = 'PURGE';
1372: --

Line 1516: update per_addresses

1512: exit;
1513: end if;
1514: --
1515: FORALL i in t_add_party_id.FIRST..t_add_party_id.LAST
1516: update per_addresses
1517: set party_id = null
1518: where party_id = t_add_party_id(i);
1519: --
1520: commit;

Line 1697: update PER_ADDRESSES

1693: **
1694: ** For performance reasons just use direct SQL and not the APIs
1695: */
1696: begin
1697: update PER_ADDRESSES
1698: set party_id = p_party_id
1699: where person_id = p_person_id;
1700: exception
1701: when no_data_found then

Line 6201: update per_addresses

6197: --
6198: -- Bulk update address records
6199: --
6200: forall i in t_elig_person_id.first..t_elig_person_id.last
6201: update per_addresses
6202: set party_id = t_party_id(i)
6203: where person_id = t_elig_person_id(i);
6204: --
6205: -- Bulk update phone records