630: END IF;
631:
632: IF l_direct_fed_bal_call = 'Y' THEN
633:
634: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
635: (p_defined_balance_id => gvr_balance(1).bal_id,
636: p_assignment_action_id => p_assignment_action_id),0);
637:
638: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
634: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
635: (p_defined_balance_id => gvr_balance(1).bal_id,
636: p_assignment_action_id => p_assignment_action_id),0);
637:
638: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
639: (p_defined_balance_id => gvr_balance(2).bal_id,
640: p_assignment_action_id => p_assignment_action_id),0);
641:
642: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
638: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
639: (p_defined_balance_id => gvr_balance(2).bal_id,
640: p_assignment_action_id => p_assignment_action_id),0);
641:
642: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
643: (p_defined_balance_id => gvr_balance(3).bal_id,
644: p_assignment_action_id => p_assignment_action_id),0);
645:
646: ELSE
644: p_assignment_action_id => p_assignment_action_id),0);
645:
646: ELSE
647:
648: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
649: (p_defined_balance_id => gvr_balance(1).bal_id,
650: p_assignment_action_id => p_assignment_action_id),0);
651:
652: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
648: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
649: (p_defined_balance_id => gvr_balance(1).bal_id,
650: p_assignment_action_id => p_assignment_action_id),0);
651:
652: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
653: (p_defined_balance_id => gvr_balance(2).bal_id,
654: p_assignment_action_id => p_assignment_action_id),0);
655:
656: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
652: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
653: (p_defined_balance_id => gvr_balance(2).bal_id,
654: p_assignment_action_id => p_assignment_action_id),0);
655:
656: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
657: (p_defined_balance_id => gvr_balance(3).bal_id,
658: p_assignment_action_id => p_assignment_action_id),0);
659:
660: gvr_balance(4).bal_value := nvl(pay_balance_pkg.get_value
656: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
657: (p_defined_balance_id => gvr_balance(3).bal_id,
658: p_assignment_action_id => p_assignment_action_id),0);
659:
660: gvr_balance(4).bal_value := nvl(pay_balance_pkg.get_value
661: (p_defined_balance_id => gvr_balance(4).bal_id,
662: p_assignment_action_id => p_assignment_action_id),0);
663:
664: gvr_balance(5).bal_value := nvl(pay_balance_pkg.get_value
660: gvr_balance(4).bal_value := nvl(pay_balance_pkg.get_value
661: (p_defined_balance_id => gvr_balance(4).bal_id,
662: p_assignment_action_id => p_assignment_action_id),0);
663:
664: gvr_balance(5).bal_value := nvl(pay_balance_pkg.get_value
665: (p_defined_balance_id => gvr_balance(5).bal_id,
666: p_assignment_action_id => p_assignment_action_id),0);
667: gvr_balance(6).bal_value := nvl(pay_balance_pkg.get_value
668: (p_defined_balance_id => gvr_balance(6).bal_id,
663:
664: gvr_balance(5).bal_value := nvl(pay_balance_pkg.get_value
665: (p_defined_balance_id => gvr_balance(5).bal_id,
666: p_assignment_action_id => p_assignment_action_id),0);
667: gvr_balance(6).bal_value := nvl(pay_balance_pkg.get_value
668: (p_defined_balance_id => gvr_balance(6).bal_id,
669: p_assignment_action_id => p_assignment_action_id),0);
670:
671: END IF;
672:
673: ELSIF
674: p_balance_name = 'A_W2_STATE_WAGES' THEN
675:
676: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
677: (p_defined_balance_id => gvr_balance(1).bal_id,
678: p_assignment_action_id => p_assignment_action_id),0);
679: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
680: (p_defined_balance_id => gvr_balance(2).bal_id,
675:
676: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
677: (p_defined_balance_id => gvr_balance(1).bal_id,
678: p_assignment_action_id => p_assignment_action_id),0);
679: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
680: (p_defined_balance_id => gvr_balance(2).bal_id,
681: p_assignment_action_id => p_assignment_action_id),0);
682: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
683: (p_defined_balance_id => gvr_balance(3).bal_id,
678: p_assignment_action_id => p_assignment_action_id),0);
679: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
680: (p_defined_balance_id => gvr_balance(2).bal_id,
681: p_assignment_action_id => p_assignment_action_id),0);
682: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
683: (p_defined_balance_id => gvr_balance(3).bal_id,
684: p_assignment_action_id => p_assignment_action_id),0);
685:
686: ELSIF p_balance_name = 'A_SS_EE_TAXABLE_PER_GRE_YTD' THEN
684: p_assignment_action_id => p_assignment_action_id),0);
685:
686: ELSIF p_balance_name = 'A_SS_EE_TAXABLE_PER_GRE_YTD' THEN
687:
688: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
689: (p_defined_balance_id => gvr_balance(1).bal_id,
690: p_assignment_action_id => p_assignment_action_id),0);
691: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
692: (p_defined_balance_id => gvr_balance(2).bal_id,
687:
688: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
689: (p_defined_balance_id => gvr_balance(1).bal_id,
690: p_assignment_action_id => p_assignment_action_id),0);
691: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
692: (p_defined_balance_id => gvr_balance(2).bal_id,
693: p_assignment_action_id => p_assignment_action_id),0);
694: ELSE
695: /* get the value of the dbi */
692: (p_defined_balance_id => gvr_balance(2).bal_id,
693: p_assignment_action_id => p_assignment_action_id),0);
694: ELSE
695: /* get the value of the dbi */
696: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
697: (p_defined_balance_id => gvr_balance(1).bal_id,
698: p_assignment_action_id => p_assignment_action_id),0);
699:
700: END IF; /* A_WAGES */
1032:
1033:
1034: /* set the context for the give Tax unit_id and jurisdiction only once in report */
1035:
1036: pay_balance_pkg.set_context ('JURISDICTION_CODE',lvc_jurisdiction);
1037: pay_balance_pkg.set_context ('TAX_UNIT_ID',lvn_tax_unit_id);
1038:
1039:
1040: -- djoshi write the utility trace over here
1033:
1034: /* set the context for the give Tax unit_id and jurisdiction only once in report */
1035:
1036: pay_balance_pkg.set_context ('JURISDICTION_CODE',lvc_jurisdiction);
1037: pay_balance_pkg.set_context ('TAX_UNIT_ID',lvn_tax_unit_id);
1038:
1039:
1040: -- djoshi write the utility trace over here
1041: /* get the assignment */