APPS.HREMPTER dependencies on PER_SECONDARY_ASS_STATUSES

Line 419: UPDATE per_secondary_ass_statuses sas

415: begin
416: hr_utility.trace('Entered delete_assign_fpf for assign '||p_assignment_id);
417: --
418: hr_utility.set_location(l_proc,1);
419: UPDATE per_secondary_ass_statuses sas
420: SET sas.end_date = p_final_process_date
421: WHERE sas.assignment_id = p_assignment_id
422: AND sas.end_date IS NULL;
423: --

Line 425: DELETE per_secondary_ass_statuses sas

421: WHERE sas.assignment_id = p_assignment_id
422: AND sas.end_date IS NULL;
423: --
424: hr_utility.set_location(l_proc,5);
425: DELETE per_secondary_ass_statuses sas
426: WHERE sas.assignment_id = p_assignment_id
427: AND sas.start_date > p_final_process_date;
428: --
429: hr_utility.set_location(l_proc,10);

Line 4210: UPDATE per_secondary_ass_statuses sas

4206: hr_utility.set_location(l_proc,32);
4207: l_effective_end_date := to_date('31/12/4712','DD/MM/YYYY');
4208: --
4209: hr_utility.set_location(l_proc,34);
4210: UPDATE per_secondary_ass_statuses sas
4211: SET sas.end_date = null
4212: WHERE sas.assignment_id = c_ass_rec.assignment_id
4213: AND sas.end_date = l_final_process_date;
4214: --