APPS.HR_DELETE dependencies on PAY_PRE_PAYMENTS

Line 521: FROM pay_pre_payments ppp

517: --
518: hr_utility.set_location('hr_delete.delete_assign_low_detail',1);
519: DELETE FROM pay_coin_anal_elements cae
520: WHERE EXISTS (SELECT ''
521: FROM pay_pre_payments ppp
522: WHERE ppp.pre_payment_id
523: = cae.pre_payment_id
524: AND EXISTS ( SELECT ''
525: FROM pay_assignment_actions paa