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 1306: update PER_PREVIOUS_EMPLOYERS

1302: raise;
1303: end;
1304:
1305: begin
1306: update PER_PREVIOUS_EMPLOYERS
1307: set party_id = null
1308: where party_id = p_party_id;
1309: exception
1310: when no_data_found then

Line 1407: from per_previous_employers pemp,

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

Line 1627: update per_previous_employers

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

Line 1776: update PER_PREVIOUS_EMPLOYERS

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

Line 6250: update per_previous_employers

6246: --
6247: -- Bulk update previous employment records
6248: --
6249: forall i in t_elig_person_id.first..t_elig_person_id.last
6250: update per_previous_employers
6251: set party_id = t_party_id(i)
6252: where person_id = t_elig_person_id(i);
6253: --
6254: end if;