3241: -- bug fix 3732129
3242: -- Delete statement modified to improve performance.
3243: --
3244: forall i in 1..l_assignment_id.count
3245: delete from pay_assignment_link_usages_f u
3246: where u.assignment_id = l_assignment_id(i);
3247:
3248: /*delete from pay_assignment_link_usages_f u
3249: where
3244: forall i in 1..l_assignment_id.count
3245: delete from pay_assignment_link_usages_f u
3246: where u.assignment_id = l_assignment_id(i);
3247:
3248: /*delete from pay_assignment_link_usages_f u
3249: where
3250: u.assignment_id in (
3251: select ass.assignment_id
3252: from per_assignments_f ass