APPS.PER_HRTCA_MERGE dependencies on PER_EVENTS

Line 75: select /*+ INDEX(per_events) */ *

71: -- Bug 3648761
72: -- Added Hint to use index for Performance.
73: --
74: cursor c_events is
75: select /*+ INDEX(per_events) */ *
76: from per_events
77: where assignment_id in (select assignment_id
78: from per_all_assignments_f
79: where person_id = p_rec.person_id);

Line 76: from per_events

72: -- Added Hint to use index for Performance.
73: --
74: cursor c_events is
75: select /*+ INDEX(per_events) */ *
76: from per_events
77: where assignment_id in (select assignment_id
78: from per_all_assignments_f
79: where person_id = p_rec.person_id);
80: --

Line 181: update per_events

177: --
178: fetch c_events into l_events;
179: exit when c_events%notfound;
180: --
181: update per_events
182: set party_id = p_rec.party_id
183: where event_id = l_events.event_id;
184: /*
185: per_events_api.update_event

Line 185: per_events_api.update_event

181: update per_events
182: set party_id = p_rec.party_id
183: where event_id = l_events.event_id;
184: /*
185: per_events_api.update_event
186: (p_event_id => l_events.event_id,
187: p_party_id => p_rec.party_id,
188: p_object_version_number => l_events.object_version_number);
189: */

Line 1284: update PER_EVENTS

1280: raise;
1281: end;
1282:
1283: begin
1284: update PER_EVENTS
1285: set party_id = null
1286: where party_id = p_party_id;
1287: exception
1288: when no_data_found then

Line 1362: from per_events eve,

1358: t_pce_party_id g_party_id_type;
1359: --
1360: cursor c_events is
1361: select eve.party_id
1362: from per_events eve,
1363: hr_tca_party_unmerge punm
1364: where eve.party_id = punm.party_id
1365: and punm.status = 'PURGE';
1366: --

Line 1492: update per_events

1488: exit;
1489: end if;
1490: --
1491: forall i in t_eve_party_id.first..t_eve_party_id.last
1492: update per_events
1493: set party_id = null
1494: where party_id = t_eve_party_id(i);
1495: --
1496: commit;

Line 1743: update PER_EVENTS

1739: from per_all_assignments_f
1740: where person_id = p_person_id;
1741:
1742: forall i in 1..l_assignment_id.count
1743: update PER_EVENTS
1744: set party_id = p_party_id
1745: where assignment_id = l_assignment_id(i);
1746:
1747: -- bug fix 3632535 ends here.

Line 1749: /*update PER_EVENTS

1745: where assignment_id = l_assignment_id(i);
1746:
1747: -- bug fix 3632535 ends here.
1748:
1749: /*update PER_EVENTS
1750: set party_id = p_party_id
1751: where assignment_id in (select assignment_id
1752: from per_all_assignments_f
1753: where person_id = p_person_id);*/

Line 6211: update per_events

6207: --
6208: -- Bulk update events records
6209: --
6210: forall i in t_elig_person_id.first..t_elig_person_id.last
6211: update per_events
6212: set party_id = t_party_id(i)
6213: where assignment_id in
6214: (select assignment_id
6215: from per_all_assignments_f