APPS.PER_HRTCA_MERGE dependencies on PER_PREVIOUS_EMPLOYERS

Line 121: from per_previous_employers

117: l_establishment_attendances c_establishment_attendances%rowtype;
118: --
119: cursor c_prev_employers is
120: select *
121: from per_previous_employers
122: where person_id = p_rec.person_id;
123: --
124: l_prev_employers c_prev_employers%rowtype;
125: --

Line 314: update per_previous_employers

310: fetch c_prev_employers into l_prev_employers;
311: exit when c_prev_employers%notfound; --Bug fix 3618727
312: --
313: --
314: update per_previous_employers
315: set party_id = p_rec.party_id
316: where previous_employer_id = l_prev_employers.previous_employer_id;
317: --
318: end loop;

Line 1303: update PER_PREVIOUS_EMPLOYERS

1299: raise;
1300: end;
1301:
1302: begin
1303: update PER_PREVIOUS_EMPLOYERS
1304: set party_id = null
1305: where party_id = p_party_id;
1306: exception
1307: when no_data_found then

Line 1404: from per_previous_employers pemp,

1400: t_esta_party_id g_party_id_type;
1401: --
1402: cursor c_prev_employers is
1403: select pemp.party_id
1404: from per_previous_employers pemp,
1405: hr_tca_party_unmerge punm
1406: where pemp.party_id = punm.party_id
1407: and punm.status = 'PURGE';
1408: --

Line 1624: update per_previous_employers

1620: --
1621: -- No API at the moment so use base table.
1622: --
1623: forall i in t_pemp_party_id.first..t_pemp_party_id.last
1624: update per_previous_employers
1625: set party_id = null
1626: where party_id = t_pemp_party_id(i);
1627: --
1628: commit;

Line 1773: update PER_PREVIOUS_EMPLOYERS

1769: raise;
1770: end;
1771:
1772: begin
1773: update PER_PREVIOUS_EMPLOYERS
1774: set party_id = p_party_id
1775: where person_id = p_person_id;
1776: exception
1777: when no_data_found then

Line 6230: update per_previous_employers

6226: --
6227: -- Bulk update previous employment records
6228: --
6229: forall i in t_elig_person_id.first..t_elig_person_id.last
6230: update per_previous_employers
6231: set party_id = t_party_id(i)
6232: where person_id = t_elig_person_id(i);
6233: --
6234: end if;