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 1251: update PER_ADDRESSES

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

Line 1371: from per_addresses addr,

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

Line 1519: update per_addresses

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

Line 1700: update PER_ADDRESSES

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

Line 6221: update per_addresses

6217: --
6218: -- Bulk update address records
6219: --
6220: forall i in t_elig_person_id.first..t_elig_person_id.last
6221: update per_addresses
6222: set party_id = t_party_id(i)
6223: where person_id = t_elig_person_id(i);
6224: --
6225: -- Bulk update phone records