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 1281: update PER_EVENTS

1277: raise;
1278: end;
1279:
1280: begin
1281: update PER_EVENTS
1282: set party_id = null
1283: where party_id = p_party_id;
1284: exception
1285: when no_data_found then

Line 1359: from per_events eve,

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

Line 1489: update per_events

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

Line 1740: update PER_EVENTS

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

Line 1746: /*update PER_EVENTS

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

Line 6191: update per_events

6187: --
6188: -- Bulk update events records
6189: --
6190: forall i in t_elig_person_id.first..t_elig_person_id.last
6191: update per_events
6192: set party_id = t_party_id(i)
6193: where assignment_id in
6194: (select assignment_id
6195: from per_all_assignments_f