eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2367: delete from pay_assignment_link_usages_f u

2363: -- bug fix 3732129
2364: -- Delete statement modified to improve performance.
2365:
2366: forall i in 1..l_assignment_id.count
2367: delete from pay_assignment_link_usages_f u
2368: where u.assignment_id = l_assignment_id(i);
2369:
2370: /*delete from pay_assignment_link_usages_f u
2371: where

Line 2370: /*delete from pay_assignment_link_usages_f u

2366: forall i in 1..l_assignment_id.count
2367: delete from pay_assignment_link_usages_f u
2368: where u.assignment_id = l_assignment_id(i);
2369:
2370: /*delete from pay_assignment_link_usages_f u
2371: where
2372: u.assignment_id in (
2373: select ass.assignment_id
2374: from per_assignments_f ass