[Home] [Help]
195: ,'Direct Payment') THEN
196:
197: update pay_balance_types
198: set balance_category_id = (SELECT BALANCE_CATEGORY_ID
199: FROM PAY_BALANCE_CATEGORIES_F
200: WHERE CATEGORY_NAME = 'Earnings'
201: AND legislation_code = lv_legislation_code)
202: where balance_type_id = ln_balance_type_id;
203:
209: ,'Voluntary Deductions') THEN
210:
211: update pay_balance_types
212: set balance_category_id = (SELECT BALANCE_CATEGORY_ID
213: FROM PAY_BALANCE_CATEGORIES_F
214: WHERE CATEGORY_NAME = 'Deductions'
215: AND legislation_code = lv_legislation_code)
216: where balance_type_id = ln_balance_type_id;
217: