APPS.HREMPTER dependencies on PER_EVENTS

Line 36: PER_BOOKINGS and PER_EVENTS.

32: Version Date Author ER/CR No. Description of Change
33: -------+---------+----------+---------+--------------------------
34: 70.0 11-FEB-93 SZWILLIA Date Created
35: 70.1 18-FEB-93 SZWILLIA Corrected deletes from
36: PER_BOOKINGS and PER_EVENTS.
37: Also, added future actions
38: check to cancellations.
39: Added messages
40: 70.2 11-MAR-93 NKHAN Added 'exit' to end

Line 359: FROM per_events pev

355: --
356: --
357: DELETE per_bookings pb
358: WHERE event_id in ( SELECT event_id
359: FROM per_events pev
360: WHERE pev.assignment_id = p_assignment_id
361: AND pev.date_start > p_actual_termination_date
362: );
363: --

Line 365: DELETE per_events pev

361: AND pev.date_start > p_actual_termination_date
362: );
363: --
364: hr_utility.set_location(l_proc,2);
365: DELETE per_events pev
366: WHERE pev.assignment_id = p_assignment_id
367: AND pev.date_start > p_actual_termination_date
368: AND pev.event_or_interview = 'E';
369: --

Line 530: FROM per_events pev

526: -- Remove bookings on employee events
527: DELETE per_bookings pb
528: WHERE pb.person_id = p_person_id
529: AND EXISTS (SELECT ''
530: FROM per_events pev
531: WHERE pev.date_start > p_actual_termination_date
532: AND pev.emp_or_apl = 'E'
533: AND pev.event_or_interview = 'E'
534: AND pb.event_id = pev.event_id);

Line 542: FROM per_events pev

538: -- interviews
539: DELETE per_bookings pb
540: WHERE pb.person_id = p_person_id
541: AND EXISTS (SELECT ''
542: FROM per_events pev
543: WHERE pev.event_id = pb.event_id
544: AND pev.date_start > p_actual_termination_date
545: AND pev.event_or_interview = 'I'
546: AND pev.assignment_id IS NOT NULL