DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 76: PERSON,35 (pay_assignment_link_usages_f)

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

Line 2438: delete from pay_assignment_link_usages_f u

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

Line 2441: /*delete from pay_assignment_link_usages_f u

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