6418: hr_utility.trace('i_get_all_assignments.assignment_id:= '||to_char(i_get_all_assignments.assignment_id)) ;
6419: hr_utility.trace('l_tax_unit_id := '||to_char(l_tax_unit_id)) ;
6420: hr_utility.trace('l_jurisdiction_code := '||l_jurisdiction_code) ;
6421:
6422: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id) ;
6423: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code) ;
6424:
6425: l_balance_value := pay_balance_pkg.get_value(
6426: l_defined_balance_id ,
6419: hr_utility.trace('l_tax_unit_id := '||to_char(l_tax_unit_id)) ;
6420: hr_utility.trace('l_jurisdiction_code := '||l_jurisdiction_code) ;
6421:
6422: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id) ;
6423: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code) ;
6424:
6425: l_balance_value := pay_balance_pkg.get_value(
6426: l_defined_balance_id ,
6427: p_assignment_id,
6421:
6422: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id) ;
6423: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code) ;
6424:
6425: l_balance_value := pay_balance_pkg.get_value(
6426: l_defined_balance_id ,
6427: p_assignment_id,
6428: nvl(l_max_pact_dt,GREATEST(l_max_asg_eff_st_dt,trunc(p_session_date,'Y')))) ;
6429:
6463:
6464: l_jurisdiction_code := i_all_curr_states.state_code || '-000-0000' ;
6465:
6466:
6467: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id) ;
6468: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code) ;
6469:
6470: l_actual_balance_value := pay_balance_pkg.get_value(
6471: l_defined_balance_id ,
6464: l_jurisdiction_code := i_all_curr_states.state_code || '-000-0000' ;
6465:
6466:
6467: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id) ;
6468: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code) ;
6469:
6470: l_actual_balance_value := pay_balance_pkg.get_value(
6471: l_defined_balance_id ,
6472: p_assignment_id,
6466:
6467: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id) ;
6468: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code) ;
6469:
6470: l_actual_balance_value := pay_balance_pkg.get_value(
6471: l_defined_balance_id ,
6472: p_assignment_id,
6473: nvl(l_max_pact_dt,GREATEST(l_max_asg_eff_st_dt,trunc(p_session_date,'Y')))) ;
6474:
6518:
6519: hr_utility.trace('l_tax_unit_id := '||to_char(l_tax_unit_id)) ;
6520: hr_utility.trace('l_jurisdiction_code := '||l_jurisdiction_code) ;
6521:
6522: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id) ;
6523: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code) ;
6524:
6525: l_balance_value := pay_balance_pkg.get_value(
6526: l_defined_balance_id ,
6519: hr_utility.trace('l_tax_unit_id := '||to_char(l_tax_unit_id)) ;
6520: hr_utility.trace('l_jurisdiction_code := '||l_jurisdiction_code) ;
6521:
6522: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id) ;
6523: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code) ;
6524:
6525: l_balance_value := pay_balance_pkg.get_value(
6526: l_defined_balance_id ,
6527: p_assignment_id,
6521:
6522: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id) ;
6523: pay_balance_pkg.set_context('JURISDICTION_CODE',l_jurisdiction_code) ;
6524:
6525: l_balance_value := pay_balance_pkg.get_value(
6526: l_defined_balance_id ,
6527: p_assignment_id,
6528: nvl(l_max_pact_dt,GREATEST(l_max_asg_eff_st_dt,trunc(p_session_date,'Y')))) ;
6529: