374: open c_defined_balance(p_balance_name);
375: fetch c_defined_balance into ln_defined_balance_id;
376: close c_defined_balance;
377:
378: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
379:
380: if p_state_abbrev <> 'FED' THEN
381: open c_jurisdiction(p_state_abbrev);
382: fetch c_jurisdiction into lv_jurisdiction_code;
384:
385: hr_utility.set_location
386: ('pay_us_1099r_mag_reporting.get_balance_value', 15);
387:
388: pay_balance_pkg.set_context('JURISDICTION_CODE', lv_jurisdiction_code);
389: end if;
390:
391: hr_utility.trace(p_balance_name);
392: hr_utility.trace('Context');
394: hr_utility.trace('Jurisdiction: '|| lv_jurisdiction_code);
395: hr_utility.set_location
396: ('pay_us_1099r_mag_reporting.get_balance_value', 20);
397:
398: ln_balance_value := pay_balance_pkg.get_value
399: (ln_defined_balance_id,
400: p_assignment_id, p_effective_date);
401:
402: hr_utility.trace('Exiting pay_us_1099r_mag_reporting.get_balance_value');