235: END IF;
236: --+
237: --+ set the tax unit id context
238: --+
239: pay_balance_pkg.set_context('tax_unit_id', l_tax_unit_id);
240: --+
241: --+ fetch the defined balance it
242: --+
243: FOR c_rec IN c_defined_bal LOOP
249: IF NVL(p_state_code, 'NULL') <> 'NULL' THEN
250: FOR c_rec IN c_jurisdiction LOOP
251: l_jd_code := c_rec.jurisdiction_code;
252: END LOOP;
253: pay_balance_pkg.set_context('jurisdiction_code', l_jd_code);
254: END IF;
255: --+
256: --+ Finally get the actual balance
257: --+
254: END IF;
255: --+
256: --+ Finally get the actual balance
257: --+
258: l_amt := pay_balance_pkg.get_value(l_def_bal_id,
259: p_assignment_id,
260: l_effective_date);
261: --+
262: RETURN l_amt;
387: END LOOP;
388:
389: --+ Set up the GRE and Jurisdicton context
390:
391: pay_balance_pkg.set_context('tax_unit_id', p_tax_unit_id);
392:
393: IF p_balance_name <> 'Non W2 FIT Withheld' THEN
394: pay_balance_pkg.set_context('jurisdiction_code',p_jurisdiction_code);
395: END IF;
390:
391: pay_balance_pkg.set_context('tax_unit_id', p_tax_unit_id);
392:
393: IF p_balance_name <> 'Non W2 FIT Withheld' THEN
394: pay_balance_pkg.set_context('jurisdiction_code',p_jurisdiction_code);
395: END IF;
396:
397: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
398: p_assignment_action_id);
393: IF p_balance_name <> 'Non W2 FIT Withheld' THEN
394: pay_balance_pkg.set_context('jurisdiction_code',p_jurisdiction_code);
395: END IF;
396:
397: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
398: p_assignment_action_id);
399: END IF;
400:
401: RETURN l_balance_amount;
630: -- on 13-Jun-2002 tmehra
631: -- pay_us_balance_view_pkg.set_context('TAX_UNIT_ID',p_gre);
632: -- pay_us_balance_view_pkg.set_context('DATE_EARNED',p_end_date);
633:
634: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre);
635: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_end_date));
636: pay_balance_pkg.set_context('BALANCE_DATE',fnd_date.date_to_canonical(p_start_date));
637:
638: IF p_bal_name = 'Non W2 FIT' THEN
631: -- pay_us_balance_view_pkg.set_context('TAX_UNIT_ID',p_gre);
632: -- pay_us_balance_view_pkg.set_context('DATE_EARNED',p_end_date);
633:
634: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre);
635: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_end_date));
636: pay_balance_pkg.set_context('BALANCE_DATE',fnd_date.date_to_canonical(p_start_date));
637:
638: IF p_bal_name = 'Non W2 FIT' THEN
639:
632: -- pay_us_balance_view_pkg.set_context('DATE_EARNED',p_end_date);
633:
634: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre);
635: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(p_end_date));
636: pay_balance_pkg.set_context('BALANCE_DATE',fnd_date.date_to_canonical(p_start_date));
637:
638: IF p_bal_name = 'Non W2 FIT' THEN
639:
640: IF p_dim = 'CTD' THEN
648: END IF;
649:
650: l_defined_bal_id := get_defined_bal_id ('Non W2 FIT Withheld',l_dimension);
651:
652: l_bal_amt := pay_balance_pkg.get_value(l_defined_bal_id
653: ,l_asg_action_id);
654: ELSIF p_bal_name = 'Non W2 SIT' THEN
655:
656: IF p_dim = 'CTD' THEN
664: END IF;
665:
666: l_defined_bal_id := get_defined_bal_id ('SIT Alien Withheld',l_dimension);
667:
668: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);
669:
670: l_bal_amt := pay_balance_pkg.get_value(l_defined_bal_id
671: ,l_asg_action_id);
672:
666: l_defined_bal_id := get_defined_bal_id ('SIT Alien Withheld',l_dimension);
667:
668: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);
669:
670: l_bal_amt := pay_balance_pkg.get_value(l_defined_bal_id
671: ,l_asg_action_id);
672:
673:
674: ELSIF p_bal_name = 'Non W2 FIT Wages' THEN
686: l_defined_bal_id := get_defined_bal_id ('FIT Alien Subj Whable',l_dimension);
687: l_def_pre_tax_id := get_defined_bal_id ('FIT Non W2 Pre Tax Dedns',l_dimension);
688:
689: l_bal_amt := l_bal_amt
690: + pay_balance_pkg.get_value(l_defined_bal_id
691: ,l_asg_action_id)
692: - pay_balance_pkg.get_value(l_def_pre_tax_id
693: ,l_asg_action_id);
694:
688:
689: l_bal_amt := l_bal_amt
690: + pay_balance_pkg.get_value(l_defined_bal_id
691: ,l_asg_action_id)
692: - pay_balance_pkg.get_value(l_def_pre_tax_id
693: ,l_asg_action_id);
694:
695: ELSIF p_bal_name = 'Non W2 SIT Wages' THEN
696:
706:
707: l_defined_bal_id := get_defined_bal_id ('SIT Alien Subj Whable',l_dimension);
708: l_def_pre_tax_id := get_defined_bal_id ('SIT Non W2 Pre Tax Dedns',l_dimension);
709:
710: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);
711:
712: l_bal_amt := l_bal_amt
713: + pay_balance_pkg.get_value(l_defined_bal_id
714: ,l_asg_action_id)
709:
710: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd);
711:
712: l_bal_amt := l_bal_amt
713: + pay_balance_pkg.get_value(l_defined_bal_id
714: ,l_asg_action_id)
715: - pay_balance_pkg.get_value(l_def_pre_tax_id
716: ,l_asg_action_id);
717: END IF;
711:
712: l_bal_amt := l_bal_amt
713: + pay_balance_pkg.get_value(l_defined_bal_id
714: ,l_asg_action_id)
715: - pay_balance_pkg.get_value(l_def_pre_tax_id
716: ,l_asg_action_id);
717: END IF;
718:
719: