APPS.HR_DELETE dependencies on PAY_RATES

Line 134: statement for PAY_RATES to avoid

130: financials_system param_all for
131: a business group.
132: b Moved the delete statement for
133: PER_PAY_BASES to before the delete
134: statement for PAY_RATES to avoid
135: the referential integrity error
136: when RATE_ID is set for a pay basis.
137: c Moved the delete statement for
138: PER_EVENTS to after the delete

Line 1562: DELETE FROM pay_rates pr

1558: DELETE FROM pay_grade_rules_f gr
1559: WHERE gr.business_group_id = p_business_group_id;
1560: --
1561: hr_utility.set_location('hr_delete.delete_org_low_detail',30);
1562: DELETE FROM pay_rates pr
1563: WHERE pr.business_group_id = p_business_group_id;
1564: hr_utility.set_location('hr_delete.delete_org_low_detail',70);
1565: --
1566: --