67: open c_tax_id(c_assignment_id => p_assignment_id
68: ,c_effective_date => p_effective_date);
69: fetch c_tax_id into l_gre_id;
70: close c_tax_id;
71: pay_balance_pkg.set_context('tax_unit_id', l_gre_id);
72: pay_balance_pkg.set_context('date_earned', p_effective_date);
73:
74: if p_legislation_code = 'US' then
75: open c_jur_code(c_assignment_id => p_assignment_id
68: ,c_effective_date => p_effective_date);
69: fetch c_tax_id into l_gre_id;
70: close c_tax_id;
71: pay_balance_pkg.set_context('tax_unit_id', l_gre_id);
72: pay_balance_pkg.set_context('date_earned', p_effective_date);
73:
74: if p_legislation_code = 'US' then
75: open c_jur_code(c_assignment_id => p_assignment_id
76: ,c_business_group_id => p_business_group_id
76: ,c_business_group_id => p_business_group_id
77: ,c_effective_date => p_effective_date);
78: fetch c_jur_code into l_jurisdiction_code;
79: close c_jur_code;
80: pay_balance_pkg.set_context('jurisdiction_code', l_jurisdiction_code);
81: End if ;
82:
83: if p_legislation_code = 'FR' then
84:
86: open c_tax_id(c_assignment_id => p_assignment_id
87: ,c_effective_date => p_effective_date);
88: fetch c_tax_id into l_gre_id;
89: close c_tax_id;
90: pay_balance_pkg.set_context('tax_unit_id', l_gre_id);
91:
92: End if ;
93:
94: /*
106: end if ;
107: close c_tax_context ;
108: */
109:
110: -- Call the pay balance pkg in date mode
111: l_balance_amount := pay_balance_pkg.get_value
112: (p_defined_balance_id
113: ,p_assignment_id
114: ,p_effective_date);
107: close c_tax_context ;
108: */
109:
110: -- Call the pay balance pkg in date mode
111: l_balance_amount := pay_balance_pkg.get_value
112: (p_defined_balance_id
113: ,p_assignment_id
114: ,p_effective_date);
115:
191: else
192: l_gre_id := null ;
193: end if ;
194:
195: pay_balance_pkg.set_context('tax_unit_id', l_gre_id);
196: pay_balance_pkg.set_context('date_earned', p_effective_date);
197:
198: -- Call the pay balance pkg in date mode
199: l_balance_amount := pay_balance_pkg.get_value
192: l_gre_id := null ;
193: end if ;
194:
195: pay_balance_pkg.set_context('tax_unit_id', l_gre_id);
196: pay_balance_pkg.set_context('date_earned', p_effective_date);
197:
198: -- Call the pay balance pkg in date mode
199: l_balance_amount := pay_balance_pkg.get_value
200: (p_defined_balance_id
194:
195: pay_balance_pkg.set_context('tax_unit_id', l_gre_id);
196: pay_balance_pkg.set_context('date_earned', p_effective_date);
197:
198: -- Call the pay balance pkg in date mode
199: l_balance_amount := pay_balance_pkg.get_value
200: (p_defined_balance_id
201: ,p_assignment_id
202: ,p_effective_date);
195: pay_balance_pkg.set_context('tax_unit_id', l_gre_id);
196: pay_balance_pkg.set_context('date_earned', p_effective_date);
197:
198: -- Call the pay balance pkg in date mode
199: l_balance_amount := pay_balance_pkg.get_value
200: (p_defined_balance_id
201: ,p_assignment_id
202: ,p_effective_date);
203:
250: ,p_defined_balance_id => p_defined_balance_id
251: ) ;
252:
253: else
254: l_balance_amount := pay_balance_pkg.get_value
255: (p_defined_balance_id
256: ,p_assignment_id
257: ,p_effective_date);
258: end if ;