72: moved all but one test from strong
73: into moderate, and added call to
74: moderate in strong after test.
75: 70.12 03-jan-96 AMills Changed HR_PERSON_DELETE.DELETE_A_
76: PERSON,35 (pay_assignment_link_usages_f)
77: to improve performance,
78: using index instead of F.T.Scan,
79: Bug 329490.
80: 70.14 03-Jul-96 SXShah Added call to ota_predel_per_validation
2434: -- bug fix 3732129
2435: -- Delete statement modified to improve performance.
2436:
2437: forall i in 1..l_assignment_id.count
2438: delete from pay_assignment_link_usages_f u
2439: where u.assignment_id = l_assignment_id(i);
2440:
2441: /*delete from pay_assignment_link_usages_f u
2442: where
2437: forall i in 1..l_assignment_id.count
2438: delete from pay_assignment_link_usages_f u
2439: where u.assignment_id = l_assignment_id(i);
2440:
2441: /*delete from pay_assignment_link_usages_f u
2442: where
2443: u.assignment_id in (
2444: select ass.assignment_id
2445: from per_assignments_f ass