DBA Data[Home] [Help]

APPS.HRHIRAPL dependencies on PER_EVENTS

Line 4460: from per_events pe

4456: l_final_no number;
4457: --
4458: cursor events is
4459: select pe.event_id
4460: from per_events pe
4461: , per_assignments_f a
4462: where pe.business_group_id +0 = a.business_group_id
4463: and a.business_group_id = p_business_group_id
4464: and pe.assignment_id = a.assignment_id

Line 4517: delete from per_events

4513: loop
4514: fetch events into l_event_id;
4515: exit when events%NOTFOUND;
4516: --
4517: delete from per_events
4518: where event_id = l_event_id;
4519: l_final_no := l_final_no - sql%rowcount;
4520: end loop;
4521: if l_final_no <> 0 then