eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_LIVEARCHIVE_PKG dependencies on PAY_BALANCE_PKG

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

579: BEGIN
580:
581: IF p_balance_name = 'A_WAGES' THEN
582:
583: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
584: (p_defined_balance_id => gvr_balance(1).bal_id,
585: p_assignment_action_id => p_assignment_action_id),0);
586:
587: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value

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

583: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
584: (p_defined_balance_id => gvr_balance(1).bal_id,
585: p_assignment_action_id => p_assignment_action_id),0);
586:
587: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
588: (p_defined_balance_id => gvr_balance(2).bal_id,
589: p_assignment_action_id => p_assignment_action_id),0);
590:
591: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value

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

587: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
588: (p_defined_balance_id => gvr_balance(2).bal_id,
589: p_assignment_action_id => p_assignment_action_id),0);
590:
591: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
592: (p_defined_balance_id => gvr_balance(3).bal_id,
593: p_assignment_action_id => p_assignment_action_id),0);
594:
595: gvr_balance(4).bal_value := nvl(pay_balance_pkg.get_value

Line 595: gvr_balance(4).bal_value := nvl(pay_balance_pkg.get_value

591: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
592: (p_defined_balance_id => gvr_balance(3).bal_id,
593: p_assignment_action_id => p_assignment_action_id),0);
594:
595: gvr_balance(4).bal_value := nvl(pay_balance_pkg.get_value
596: (p_defined_balance_id => gvr_balance(4).bal_id,
597: p_assignment_action_id => p_assignment_action_id),0);
598:
599: gvr_balance(5).bal_value := nvl(pay_balance_pkg.get_value

Line 599: gvr_balance(5).bal_value := nvl(pay_balance_pkg.get_value

595: gvr_balance(4).bal_value := nvl(pay_balance_pkg.get_value
596: (p_defined_balance_id => gvr_balance(4).bal_id,
597: p_assignment_action_id => p_assignment_action_id),0);
598:
599: gvr_balance(5).bal_value := nvl(pay_balance_pkg.get_value
600: (p_defined_balance_id => gvr_balance(5).bal_id,
601: p_assignment_action_id => p_assignment_action_id),0);
602: gvr_balance(6).bal_value := nvl(pay_balance_pkg.get_value
603: (p_defined_balance_id => gvr_balance(6).bal_id,

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

598:
599: gvr_balance(5).bal_value := nvl(pay_balance_pkg.get_value
600: (p_defined_balance_id => gvr_balance(5).bal_id,
601: p_assignment_action_id => p_assignment_action_id),0);
602: gvr_balance(6).bal_value := nvl(pay_balance_pkg.get_value
603: (p_defined_balance_id => gvr_balance(6).bal_id,
604: p_assignment_action_id => p_assignment_action_id),0);
605:
606: ELSIF

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

605:
606: ELSIF
607: p_balance_name = 'A_W2_STATE_WAGES' THEN
608:
609: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
610: (p_defined_balance_id => gvr_balance(1).bal_id,
611: p_assignment_action_id => p_assignment_action_id),0);
612: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
613: (p_defined_balance_id => gvr_balance(2).bal_id,

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

608:
609: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
610: (p_defined_balance_id => gvr_balance(1).bal_id,
611: p_assignment_action_id => p_assignment_action_id),0);
612: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
613: (p_defined_balance_id => gvr_balance(2).bal_id,
614: p_assignment_action_id => p_assignment_action_id),0);
615: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
616: (p_defined_balance_id => gvr_balance(3).bal_id,

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

611: p_assignment_action_id => p_assignment_action_id),0);
612: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
613: (p_defined_balance_id => gvr_balance(2).bal_id,
614: p_assignment_action_id => p_assignment_action_id),0);
615: gvr_balance(3).bal_value := nvl(pay_balance_pkg.get_value
616: (p_defined_balance_id => gvr_balance(3).bal_id,
617: p_assignment_action_id => p_assignment_action_id),0);
618:
619: ELSIF p_balance_name = 'A_SS_EE_TAXABLE_PER_GRE_YTD' THEN

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

617: p_assignment_action_id => p_assignment_action_id),0);
618:
619: ELSIF p_balance_name = 'A_SS_EE_TAXABLE_PER_GRE_YTD' THEN
620:
621: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
622: (p_defined_balance_id => gvr_balance(1).bal_id,
623: p_assignment_action_id => p_assignment_action_id),0);
624: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
625: (p_defined_balance_id => gvr_balance(2).bal_id,

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

620:
621: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
622: (p_defined_balance_id => gvr_balance(1).bal_id,
623: p_assignment_action_id => p_assignment_action_id),0);
624: gvr_balance(2).bal_value := nvl(pay_balance_pkg.get_value
625: (p_defined_balance_id => gvr_balance(2).bal_id,
626: p_assignment_action_id => p_assignment_action_id),0);
627: ELSE
628: /* get the value of the dbi */

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

625: (p_defined_balance_id => gvr_balance(2).bal_id,
626: p_assignment_action_id => p_assignment_action_id),0);
627: ELSE
628: /* get the value of the dbi */
629: gvr_balance(1).bal_value := nvl(pay_balance_pkg.get_value
630: (p_defined_balance_id => gvr_balance(1).bal_id,
631: p_assignment_action_id => p_assignment_action_id),0);
632:
633: END IF; /* A_WAGES */

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

943:
944:
945: /* set the context for the give Tax unit_id and jurisdiction only once in report */
946:
947: pay_balance_pkg.set_context ('JURISDICTION_CODE',lvc_jurisdiction);
948: pay_balance_pkg.set_context ('TAX_UNIT_ID',lvn_tax_unit_id);
949:
950:
951: -- djoshi write the utility trace over here

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

944:
945: /* set the context for the give Tax unit_id and jurisdiction only once in report */
946:
947: pay_balance_pkg.set_context ('JURISDICTION_CODE',lvc_jurisdiction);
948: pay_balance_pkg.set_context ('TAX_UNIT_ID',lvn_tax_unit_id);
949:
950:
951: -- djoshi write the utility trace over here
952: /* get the assignment */