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);
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);
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;
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);
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:
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:
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');
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;
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;
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;
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;
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;
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;
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;
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');
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:
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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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: