DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PER_ORGANIZATION_LIST

Line 255: 115.30 11-MAY-04 smparame 3622082 Modified the delete from per_organization_list in

251: 115.28 12-DEC-03 nbristow Now delete from pay_upgrade_status.
252: 115.29 30-APR-04 alogue Performance Repository : remove deletion from
253: pay_quickpay_inclusions as occurs within rollback
254: anyway.
255: 115.30 11-MAY-04 smparame 3622082 Modified the delete from per_organization_list in
256: delete_secure_objects procedure to improve
257: performance.
258: 115.31 24-MAY-04 alogue 3640651 Performance Repository fixes:
259: Rewrote delete_formula_direct.

Line 2251: DELETE FROM per_organization_list ol

2247:
2248: -- Bug fix 3622082.
2249: -- Delete statement modified to improve performance.
2250:
2251: DELETE FROM per_organization_list ol
2252: WHERE ol.organization_id IN ( SELECT ou.organization_id
2253: FROM hr_all_organization_units ou
2254: WHERE ou.business_group_id = p_business_group_id);
2255: --