DBA Data[Home] [Help]

APPS.PAY_LIVEARCHIVE_PKG dependencies on PAY_BALANCE_PKG

Line 634: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value

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

Line 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

Line 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

Line 648: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value

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

Line 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

Line 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

Line 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

Line 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,

Line 667: gvr_balance(6).bal_value := nvl(pay_balance_pkg.get_value

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;

Line 676: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value

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,

Line 679: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value

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,

Line 682: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value

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

Line 688: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value

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,

Line 691: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value

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 */

Line 696: gvr_balance(1).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 */
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 */

Line 1036: pay_balance_pkg.set_context ('JURISDICTION_CODE',lvc_jurisdiction);

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

Line 1037: pay_balance_pkg.set_context ('TAX_UNIT_ID',lvn_tax_unit_id);

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 */