DBA Data[Home] [Help]

APPS.HRHIRAPL dependencies on PER_EVENTS

Line 5069: from per_events pe

5065: l_final_no number;
5066: --
5067: cursor events is
5068: select pe.event_id
5069: from per_events pe
5070: , per_assignments_f a
5071: where pe.business_group_id +0 = a.business_group_id
5072: and a.business_group_id = p_business_group_id
5073: and pe.assignment_id = a.assignment_id

Line 5126: delete from per_events

5122: loop
5123: fetch events into l_event_id;
5124: exit when events%NOTFOUND;
5125: --
5126: delete from per_events
5127: where event_id = l_event_id;
5128: l_final_no := l_final_no - sql%rowcount;
5129: end loop;
5130: if l_final_no <> 0 then