APPS.HREMPTER dependencies on PER_SECONDARY_ASS_STATUSES

Line 407: UPDATE per_secondary_ass_statuses sas

403: begin
404: hr_utility.trace('Entered delete_assign_fpf for assign '||p_assignment_id);
405: --
406: hr_utility.set_location(l_proc,1);
407: UPDATE per_secondary_ass_statuses sas
408: SET sas.end_date = p_final_process_date
409: WHERE sas.assignment_id = p_assignment_id
410: AND sas.end_date IS NULL;
411: --

Line 413: DELETE per_secondary_ass_statuses sas

409: WHERE sas.assignment_id = p_assignment_id
410: AND sas.end_date IS NULL;
411: --
412: hr_utility.set_location(l_proc,5);
413: DELETE per_secondary_ass_statuses sas
414: WHERE sas.assignment_id = p_assignment_id
415: AND sas.start_date > p_final_process_date;
416: --
417: hr_utility.set_location(l_proc,10);

Line 4060: UPDATE per_secondary_ass_statuses sas

4056: hr_utility.set_location(l_proc,32);
4057: l_effective_end_date := to_date('31/12/4712','DD/MM/YYYY');
4058: --
4059: hr_utility.set_location(l_proc,34);
4060: UPDATE per_secondary_ass_statuses sas
4061: SET sas.end_date = null
4062: WHERE sas.assignment_id = c_ass_rec.assignment_id
4063: AND sas.end_date = l_final_process_date;
4064: --