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_FI_ARCHIVE_MTRA dependencies on PAY_BALANCE_PKG

Line 544: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);

540:
541: hr_utility.set_location('Entered Procedure GETDATA',10);
542:
543: BEGIN
544: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
545: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
546: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_date));
547: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
548: pay_balance_pkg.set_context('SOURCE_ID',NULL);

Line 545: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);

541: hr_utility.set_location('Entered Procedure GETDATA',10);
542:
543: BEGIN
544: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
545: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
546: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_date));
547: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
548: pay_balance_pkg.set_context('SOURCE_ID',NULL);
549: pay_balance_pkg.set_context('TAX_GROUP',NULL);

Line 546: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_date));

542:
543: BEGIN
544: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
545: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
546: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_date));
547: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
548: pay_balance_pkg.set_context('SOURCE_ID',NULL);
549: pay_balance_pkg.set_context('TAX_GROUP',NULL);
550: END;

Line 547: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);

543: BEGIN
544: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
545: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
546: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_date));
547: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
548: pay_balance_pkg.set_context('SOURCE_ID',NULL);
549: pay_balance_pkg.set_context('TAX_GROUP',NULL);
550: END;
551: hr_utility.set_location('Set the contexts',20);

Line 548: pay_balance_pkg.set_context('SOURCE_ID',NULL);

544: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
545: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
546: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_date));
547: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
548: pay_balance_pkg.set_context('SOURCE_ID',NULL);
549: pay_balance_pkg.set_context('TAX_GROUP',NULL);
550: END;
551: hr_utility.set_location('Set the contexts',20);
552:

Line 549: pay_balance_pkg.set_context('TAX_GROUP',NULL);

545: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
546: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_date));
547: pay_balance_pkg.set_context('JURISDICTION_CODE',NULL);
548: pay_balance_pkg.set_context('SOURCE_ID',NULL);
549: pay_balance_pkg.set_context('TAX_GROUP',NULL);
550: END;
551: hr_utility.set_location('Set the contexts',20);
552:
553:

Line 635: l_ts_deduction := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

631: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
632:
633: CLOSE csr_Get_Defined_Balance_Id;
634:
635: l_ts_deduction := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
636:
637:
638:
639: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_LU_MONTH');

Line 643: l_wt_deduction := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

639: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_LU_MONTH');
640: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
641: CLOSE csr_Get_Defined_Balance_Id;
642:
643: l_wt_deduction := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
644:
645:
646: OPEN csr_Get_Defined_Balance_Id( 'VAT_LU_MONTH');
647: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 650: l_vat_bal := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

646: OPEN csr_Get_Defined_Balance_Id( 'VAT_LU_MONTH');
647: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
648: CLOSE csr_Get_Defined_Balance_Id;
649:
650: l_vat_bal := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
651:
652: OPEN csr_Get_Defined_Balance_Id( 'SALARIES_SUBJECT_TO_WITHHOLD_TAX_LU_MONTH');
653: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
654: CLOSE csr_Get_Defined_Balance_Id;

Line 656: l_Sal_subject_Wt :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

652: OPEN csr_Get_Defined_Balance_Id( 'SALARIES_SUBJECT_TO_WITHHOLD_TAX_LU_MONTH');
653: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
654: CLOSE csr_Get_Defined_Balance_Id;
655:
656: l_Sal_subject_Wt :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
657:
658: OPEN csr_Get_Defined_Balance_Id( 'SALARIES_SUBJECT_TO_TAX_AT_SOURCE_LU_MONTH');
659: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
660: CLOSE csr_Get_Defined_Balance_Id;

Line 664: l_Sal_subject_Ts := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

660: CLOSE csr_Get_Defined_Balance_Id;
661:
662:
663:
664: l_Sal_subject_Ts := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
665:
666: OPEN csr_Get_Defined_Balance_Id( 'PAYMENTS_SUBJECT_TO_WITHHOLD_TAX_LU_MONTH');
667: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
668: CLOSE csr_Get_Defined_Balance_Id;

Line 670: l_Pay_subject_Wt := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

666: OPEN csr_Get_Defined_Balance_Id( 'PAYMENTS_SUBJECT_TO_WITHHOLD_TAX_LU_MONTH');
667: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
668: CLOSE csr_Get_Defined_Balance_Id;
669:
670: l_Pay_subject_Wt := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
671:
672: OPEN csr_Get_Defined_Balance_Id( 'PAYMENTS_SUBJECT_TO_TAX_AT_SOURCE_LU_MONTH');
673: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
674: CLOSE csr_Get_Defined_Balance_Id;

Line 676: l_Pay_subject_ts := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

672: OPEN csr_Get_Defined_Balance_Id( 'PAYMENTS_SUBJECT_TO_TAX_AT_SOURCE_LU_MONTH');
673: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
674: CLOSE csr_Get_Defined_Balance_Id;
675:
676: l_Pay_subject_ts := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
677:
678:
679: OPEN csr_Get_Defined_Balance_Id( 'SOCIAL_SECURITY_LU_MONTH');
680: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 683: l_ss_fee :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

679: OPEN csr_Get_Defined_Balance_Id( 'SOCIAL_SECURITY_LU_MONTH');
680: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
681: CLOSE csr_Get_Defined_Balance_Id;
682:
683: l_ss_fee :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
684:
685: OPEN csr_Get_Defined_Balance_Id( 'EXEMPTED_SOCIAL_SECURITY_LU_MONTH');
686: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
687: CLOSE csr_Get_Defined_Balance_Id;

Line 689: l_exem_ss_fee := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

685: OPEN csr_Get_Defined_Balance_Id( 'EXEMPTED_SOCIAL_SECURITY_LU_MONTH');
686: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
687: CLOSE csr_Get_Defined_Balance_Id;
688:
689: l_exem_ss_fee := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
690:
691:
692:
693: OPEN csr_Get_Defined_Balance_Id( 'INSURANCE_SALARY_LU_MONTH');

Line 697: l_ins_ss_fee := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );

693: OPEN csr_Get_Defined_Balance_Id( 'INSURANCE_SALARY_LU_MONTH');
694: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
695: CLOSE csr_Get_Defined_Balance_Id;
696:
697: l_ins_ss_fee := pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id );
698:
699: l_employer_ss_fee := nvl(l_ss_fee,0) + nvl(l_exem_ss_fee,0) + nvl(l_ins_ss_fee ,0) ;
700: ELSE
701:

Line 758: l_ts_deduction := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

754: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE_LE_MONTH');
755: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
756: CLOSE csr_Get_Defined_Balance_Id;
757:
758: l_ts_deduction := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
759:
760: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_LE_MONTH');
761: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
762: CLOSE csr_Get_Defined_Balance_Id;

Line 764: l_wt_deduction := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

760: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_LE_MONTH');
761: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
762: CLOSE csr_Get_Defined_Balance_Id;
763:
764: l_wt_deduction := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
765:
766:
767: OPEN csr_Get_Defined_Balance_Id( 'VAT_LE_MONTH');
768: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 771: l_vat_bal := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

767: OPEN csr_Get_Defined_Balance_Id( 'VAT_LE_MONTH');
768: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
769: CLOSE csr_Get_Defined_Balance_Id;
770:
771: l_vat_bal := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
772:
773: OPEN csr_Get_Defined_Balance_Id( 'SALARIES_SUBJECT_TO_WITHHOLD_TAX_LE_MONTH');
774: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
775: CLOSE csr_Get_Defined_Balance_Id;

Line 777: l_Sal_subject_Wt := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

773: OPEN csr_Get_Defined_Balance_Id( 'SALARIES_SUBJECT_TO_WITHHOLD_TAX_LE_MONTH');
774: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
775: CLOSE csr_Get_Defined_Balance_Id;
776:
777: l_Sal_subject_Wt := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
778:
779: OPEN csr_Get_Defined_Balance_Id( 'SALARIES_SUBJECT_TO_TAX_AT_SOURCE_LE_MONTH');
780: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
781: CLOSE csr_Get_Defined_Balance_Id;

Line 783: l_Sal_subject_Ts := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

779: OPEN csr_Get_Defined_Balance_Id( 'SALARIES_SUBJECT_TO_TAX_AT_SOURCE_LE_MONTH');
780: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
781: CLOSE csr_Get_Defined_Balance_Id;
782:
783: l_Sal_subject_Ts := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
784:
785: OPEN csr_Get_Defined_Balance_Id( 'PAYMENTS_SUBJECT_TO_WITHHOLD_TAX_LE_MONTH');
786: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
787: CLOSE csr_Get_Defined_Balance_Id;

Line 789: l_Pay_subject_Wt := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

785: OPEN csr_Get_Defined_Balance_Id( 'PAYMENTS_SUBJECT_TO_WITHHOLD_TAX_LE_MONTH');
786: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
787: CLOSE csr_Get_Defined_Balance_Id;
788:
789: l_Pay_subject_Wt := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
790:
791: OPEN csr_Get_Defined_Balance_Id( 'PAYMENTS_SUBJECT_TO_TAX_AT_SOURCE_LE_MONTH');
792: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
793: CLOSE csr_Get_Defined_Balance_Id;

Line 795: l_Pay_subject_ts := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

791: OPEN csr_Get_Defined_Balance_Id( 'PAYMENTS_SUBJECT_TO_TAX_AT_SOURCE_LE_MONTH');
792: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
793: CLOSE csr_Get_Defined_Balance_Id;
794:
795: l_Pay_subject_ts := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
796:
797:
798: OPEN csr_Get_Defined_Balance_Id( 'SOCIAL_SECURITY_LE_MONTH');
799: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;

Line 802: l_ss_fee := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

798: OPEN csr_Get_Defined_Balance_Id( 'SOCIAL_SECURITY_LE_MONTH');
799: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
800: CLOSE csr_Get_Defined_Balance_Id;
801:
802: l_ss_fee := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
803:
804: OPEN csr_Get_Defined_Balance_Id( 'EXEMPTED_SOCIAL_SECURITY_LE_MONTH');
805: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
806: CLOSE csr_Get_Defined_Balance_Id;

Line 808: l_exem_ss_fee := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

804: OPEN csr_Get_Defined_Balance_Id( 'EXEMPTED_SOCIAL_SECURITY_LE_MONTH');
805: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
806: CLOSE csr_Get_Defined_Balance_Id;
807:
808: l_exem_ss_fee := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
809:
810: OPEN csr_Get_Defined_Balance_Id( 'INSURANCE_SALARY_LE_MONTH');
811: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
812: CLOSE csr_Get_Defined_Balance_Id;

Line 814: l_ins_ss_fee := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );

810: OPEN csr_Get_Defined_Balance_Id( 'INSURANCE_SALARY_LE_MONTH');
811: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
812: CLOSE csr_Get_Defined_Balance_Id;
813:
814: l_ins_ss_fee := pay_balance_pkg.get_value(lr_Get_Defined_Balance_Id.creator_id,NULL, l_legal_employer_id, NULL, NULL, NULL, l_reporting_date );
815:
816: l_employer_ss_fee := nvl(l_ss_fee,0) + nvl(l_exem_ss_fee,0) + nvl(l_ins_ss_fee ,0) ;
817:
818:

Line 886: l_subsidy_for_low_paid_emp := pay_balance_pkg.get_value(p_defined_balance_id => lr_Get_Defined_Balance_Id.creator_id,

882: open csr_get_defined_balance_id( l_subsidy_for_low_paid_bal);
883: fetch csr_get_defined_balance_id into lr_get_defined_balance_id;
884: close csr_get_defined_balance_id;
885:
886: l_subsidy_for_low_paid_emp := pay_balance_pkg.get_value(p_defined_balance_id => lr_Get_Defined_Balance_Id.creator_id,
887: p_assignment_id => rec_prepaid_assignments.assignment_id,
888: p_virtual_date => l_ele_effective_date
889: );
890: