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 371: FROM per_events pev

367: --
368: --
369: DELETE per_bookings pb
370: WHERE event_id in ( SELECT event_id
371: FROM per_events pev
372: WHERE pev.assignment_id = p_assignment_id
373: AND pev.date_start > p_actual_termination_date
374: );
375: --

Line 377: DELETE per_events pev

373: AND pev.date_start > p_actual_termination_date
374: );
375: --
376: hr_utility.set_location(l_proc,2);
377: DELETE per_events pev
378: WHERE pev.assignment_id = p_assignment_id
379: AND pev.date_start > p_actual_termination_date
380: AND pev.event_or_interview = 'E';
381: --

Line 542: FROM per_events pev

538: -- Remove bookings on employee events
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.date_start > p_actual_termination_date
544: AND pev.emp_or_apl = 'E'
545: AND pev.event_or_interview = 'E'
546: AND pb.event_id = pev.event_id);

Line 554: FROM per_events pev

550: -- interviews
551: DELETE per_bookings pb
552: WHERE pb.person_id = p_person_id
553: AND EXISTS (SELECT ''
554: FROM per_events pev
555: WHERE pev.event_id = pb.event_id
556: AND pev.date_start > p_actual_termination_date
557: AND pev.event_or_interview = 'I'
558: AND pev.assignment_id IS NOT NULL