19: update pay_defined_balances
20: set grossup_allowed_flag = 'Y'
21: where defined_balance_id = l_defbal_id;
22:
23: hr_utility.trace('Updated defined balance id : '||l_defbal_id);
24: --
25: EXCEPTION
26: when no_data_found then
27: --
38: p_baldim_id,
39: 'US',
40: 'N',
41: 'Y');
42: hr_utility.trace('Inserted balance_type_id : '||p_baltype_id);
43: hr_utility.trace('Inserted balance_dim_id : '||p_baldim_id);
44:
45: END;
46: --
39: 'US',
40: 'N',
41: 'Y');
42: hr_utility.trace('Inserted balance_type_id : '||p_baltype_id);
43: hr_utility.trace('Inserted balance_dim_id : '||p_baldim_id);
44:
45: END;
46: --
47: END setup_grossup_bal;
82:
83: delete from pay_balance_context_values
84: where latest_balance_id = latebal_rec.latest_balance_id;
85:
86: --hr_utility.trace('Deleted context value '||latebal_rec.latest_balance_id);
87:
88: --
89: delete from pay_assignment_latest_balances
90: where latest_balance_id = latebal_rec.latest_balance_id;
88: --
89: delete from pay_assignment_latest_balances
90: where latest_balance_id = latebal_rec.latest_balance_id;
91:
92: --hr_utility.trace('Deleted asg late bal '||latebal_rec.latest_balance_id);
93:
94: if l_count = 100 then
95: l_count := 0;
96: commit;