[Home] [Help]
114: transfers are rolled back.
115: 70.31 06-NOV-95 nbristow delete_bal_load_struct now deletes from
116: pay_message_lines rather that doing a
117: full rollback of the batch upload.
118: 70.32 17-JAN-96 nbristow Now deleting from per_pay_bases,
119: pay_freq_rule_periods,
120: pay_ele_freq_rules and
121: ben_benefit_contributions_f.
122: 70.33 22-JAN-96 mhoyes Added delete statements to
129: delete_bg_misc to delete
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
992: end if;
993: close csr_get_asg;
994: hr_utility.set_location(l_proc, 270);
995: --
996: DELETE FROM per_pay_bases
997: WHERE business_group_id = p_business_group_id;
998: hr_utility.set_location(l_proc,160);
999: --
1000: -- Check if career paths exist for the business group