DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PAY_ASSIGNMENT_LINK_USAGES

Line 964: DELETE FROM pay_assignment_link_usages alu

960: WHERE pa.assignment_id = qrt.assignment_id
961: AND pa.business_group_id = p_business_group_id);
962: hr_utility.set_location(l_proc,230);
963: --
964: DELETE FROM pay_assignment_link_usages alu
965: WHERE EXISTS ( SELECT ''
966: FROM per_assignments_f pa
967: WHERE pa.assignment_id = alu.assignment_id
968: AND pa.business_group_id = p_business_group_id);