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

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

895:
896:
897:
898: /* Setting contexts for balances*/
899: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
900: pay_balance_pkg.set_context('JURISDICTION_CODE',l_municipal_no);
901: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_end_date));
902:
903: IF g_debug THEN

Line 900: pay_balance_pkg.set_context('JURISDICTION_CODE',l_municipal_no);

896:
897:
898: /* Setting contexts for balances*/
899: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
900: pay_balance_pkg.set_context('JURISDICTION_CODE',l_municipal_no);
901: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_end_date));
902:
903: IF g_debug THEN
904: hr_utility.set_location(' Inside Procedure RANGE_CODE',50);

Line 901: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_end_date));

897:
898: /* Setting contexts for balances*/
899: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
900: pay_balance_pkg.set_context('JURISDICTION_CODE',l_municipal_no);
901: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_reporting_end_date));
902:
903: IF g_debug THEN
904: hr_utility.set_location(' Inside Procedure RANGE_CODE',50);
905: END IF;

Line 939: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.organization_id);

935:
936: FOR lu_dtls_rec IN csr_lu_dtls(l_legal_employer_id )
937: LOOP
938:
939: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.organization_id);
940:
941: -- get defined balance ids
942: l_def_bal_id := get_defined_balance_id('Employer Contribution Over 62 Base','_TU_MU_LU_BIMONTH') ;
943: l_to_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 943: l_to_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

939: pay_balance_pkg.set_context('LOCAL_UNIT_ID',lu_dtls_rec.organization_id);
940:
941: -- get defined balance ids
942: l_def_bal_id := get_defined_balance_id('Employer Contribution Over 62 Base','_TU_MU_LU_BIMONTH') ;
943: l_to_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
944: l_o_contribution_basis := l_to_contribution_basis + l_o_contribution_basis;
945:
946: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
947: l_tu_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 947: l_tu_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

943: l_to_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
944: l_o_contribution_basis := l_to_contribution_basis + l_o_contribution_basis;
945:
946: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
947: l_tu_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
948: l_u_contribution_basis := l_tu_contribution_basis + l_u_contribution_basis;
949:
950: l_def_bal_id := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
951: l_to_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 951: l_to_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

947: l_tu_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
948: l_u_contribution_basis := l_tu_contribution_basis + l_u_contribution_basis;
949:
950: l_def_bal_id := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
951: l_to_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
952: l_o_calc_contribution := l_to_calc_contribution + l_o_calc_contribution;
953:
954: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
955: l_tu_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 955: l_tu_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

951: l_to_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
952: l_o_calc_contribution := l_to_calc_contribution + l_o_calc_contribution;
953:
954: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
955: l_tu_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
956: l_u_calc_contribution := l_tu_calc_contribution + l_u_calc_contribution;
957:
958: l_def_bal_id := get_defined_balance_id('Tax','_TU_MU_LU_BIMONTH') ;
959: l_tWitholding_Tax := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 959: l_tWitholding_Tax := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

955: l_tu_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
956: l_u_calc_contribution := l_tu_calc_contribution + l_u_calc_contribution;
957:
958: l_def_bal_id := get_defined_balance_id('Tax','_TU_MU_LU_BIMONTH') ;
959: l_tWitholding_Tax := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
960: l_Witholding_Tax := l_Witholding_Tax + l_tWitholding_Tax;
961:
962: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_MU_LU_BIMONTH') ;
963: l_tfe_spr_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 963: l_tfe_spr_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

959: l_tWitholding_Tax := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
960: l_Witholding_Tax := l_Witholding_Tax + l_tWitholding_Tax;
961:
962: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_MU_LU_BIMONTH') ;
963: l_tfe_spr_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
964: l_fe_spr_contribution_basis := l_fe_spr_contribution_basis + l_tfe_spr_contribution_basis;
965:
966: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_MU_LU_BIMONTH') ;
967: l_tfe_spr_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 967: l_tfe_spr_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

963: l_tfe_spr_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
964: l_fe_spr_contribution_basis := l_fe_spr_contribution_basis + l_tfe_spr_contribution_basis;
965:
966: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_MU_LU_BIMONTH') ;
967: l_tfe_spr_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
968: l_fe_spr_calc_contribution := l_fe_spr_calc_contribution + l_tfe_spr_calc_contribution;
969:
970: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_MU_LU_BIMONTH') ;
971: l_tfe_fma_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 971: l_tfe_fma_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

967: l_tfe_spr_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
968: l_fe_spr_calc_contribution := l_fe_spr_calc_contribution + l_tfe_spr_calc_contribution;
969:
970: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_MU_LU_BIMONTH') ;
971: l_tfe_fma_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
972: l_fe_fma_calc_contribution := l_fe_fma_calc_contribution + l_tfe_fma_calc_contribution;
973:
974: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_MU_LU_YTD') ;
975: l_t_emp_contri_el := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 975: l_t_emp_contri_el := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

971: l_tfe_fma_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
972: l_fe_fma_calc_contribution := l_fe_fma_calc_contribution + l_tfe_fma_calc_contribution;
973:
974: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_MU_LU_YTD') ;
975: l_t_emp_contri_el := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
976: l_emp_contri_el := l_t_emp_contri_el + l_emp_contri_el;
977:
978: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_MU_LU_BIMONTH') ;
979: l_t_emp_contri_el_bimonth := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 979: l_t_emp_contri_el_bimonth := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

975: l_t_emp_contri_el := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
976: l_emp_contri_el := l_t_emp_contri_el + l_emp_contri_el;
977:
978: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_MU_LU_BIMONTH') ;
979: l_t_emp_contri_el_bimonth := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
980: l_emp_contri_el_bimonth := l_t_emp_contri_el_bimonth + l_emp_contri_el_bimonth;
981:
982: /* Resetting the values*/
983: l_to_contribution_basis:=0;

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

996:
997:
998: ELSE
999:
1000: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1001:
1002: -- get defined balance ids
1003: l_def_bal_id := get_defined_balance_id('Employer Contribution Over 62 Base','_TU_MU_LU_BIMONTH') ;
1004: l_o_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 1004: l_o_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1000: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id);
1001:
1002: -- get defined balance ids
1003: l_def_bal_id := get_defined_balance_id('Employer Contribution Over 62 Base','_TU_MU_LU_BIMONTH') ;
1004: l_o_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1005:
1006: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
1007: l_u_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1008:

Line 1007: l_u_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1003: l_def_bal_id := get_defined_balance_id('Employer Contribution Over 62 Base','_TU_MU_LU_BIMONTH') ;
1004: l_o_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1005:
1006: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
1007: l_u_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1008:
1009: l_def_bal_id := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
1010: l_to_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1011: l_o_calc_contribution := l_to_calc_contribution + l_o_calc_contribution;

Line 1010: l_to_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1006: l_def_bal_id := get_defined_balance_id('Employer Contribution Base','_TU_MU_LU_BIMONTH') ;
1007: l_u_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1008:
1009: l_def_bal_id := get_defined_balance_id('Employer Contribution Over 62','_TU_MU_LU_BIMONTH') ;
1010: l_to_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1011: l_o_calc_contribution := l_to_calc_contribution + l_o_calc_contribution;
1012:
1013: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
1014: l_tu_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 1014: l_tu_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1010: l_to_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1011: l_o_calc_contribution := l_to_calc_contribution + l_o_calc_contribution;
1012:
1013: l_def_bal_id := get_defined_balance_id('Employer Contribution','_TU_MU_LU_BIMONTH') ;
1014: l_tu_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1015: l_u_calc_contribution := l_tu_calc_contribution + l_u_calc_contribution;
1016:
1017: l_def_bal_id := get_defined_balance_id('Tax','_TU_MU_LU_BIMONTH') ;
1018: l_Witholding_Tax := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 1018: l_Witholding_Tax := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1014: l_tu_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1015: l_u_calc_contribution := l_tu_calc_contribution + l_u_calc_contribution;
1016:
1017: l_def_bal_id := get_defined_balance_id('Tax','_TU_MU_LU_BIMONTH') ;
1018: l_Witholding_Tax := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1019:
1020: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_MU_LU_BIMONTH') ;
1021: l_tfe_spr_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1022: l_fe_spr_contribution_basis := l_fe_spr_contribution_basis + l_tfe_spr_contribution_basis;

Line 1021: l_tfe_spr_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1017: l_def_bal_id := get_defined_balance_id('Tax','_TU_MU_LU_BIMONTH') ;
1018: l_Witholding_Tax := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1019:
1020: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage Base','_TU_MU_LU_BIMONTH') ;
1021: l_tfe_spr_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1022: l_fe_spr_contribution_basis := l_fe_spr_contribution_basis + l_tfe_spr_contribution_basis;
1023:
1024: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_MU_LU_BIMONTH') ;
1025: l_tfe_spr_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 1025: l_tfe_spr_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1021: l_tfe_spr_contribution_basis := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1022: l_fe_spr_contribution_basis := l_fe_spr_contribution_basis + l_tfe_spr_contribution_basis;
1023:
1024: l_def_bal_id := get_defined_balance_id('Employer Contribution Special Percentage','_TU_MU_LU_BIMONTH') ;
1025: l_tfe_spr_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1026: l_fe_spr_calc_contribution := l_fe_spr_calc_contribution + l_tfe_spr_calc_contribution;
1027:
1028: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_MU_LU_BIMONTH') ;
1029: l_tfe_fma_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 1029: l_tfe_fma_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1025: l_tfe_spr_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1026: l_fe_spr_calc_contribution := l_fe_spr_calc_contribution + l_tfe_spr_calc_contribution;
1027:
1028: l_def_bal_id := get_defined_balance_id('Employer Contribution Special','_TU_MU_LU_BIMONTH') ;
1029: l_tfe_fma_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1030: l_fe_fma_calc_contribution := l_fe_fma_calc_contribution + l_tfe_fma_calc_contribution;
1031:
1032: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_MU_LU_YTD') ;
1033: l_t_emp_contri_el := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 1033: l_t_emp_contri_el := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1029: l_tfe_fma_calc_contribution := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1030: l_fe_fma_calc_contribution := l_fe_fma_calc_contribution + l_tfe_fma_calc_contribution;
1031:
1032: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_MU_LU_YTD') ;
1033: l_t_emp_contri_el := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1034: l_emp_contri_el := l_t_emp_contri_el + l_emp_contri_el;
1035:
1036: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_MU_LU_BIMONTH') ;
1037: l_t_emp_contri_el_bimonth := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

Line 1037: l_t_emp_contri_el_bimonth := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);

1033: l_t_emp_contri_el := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1034: l_emp_contri_el := l_t_emp_contri_el + l_emp_contri_el;
1035:
1036: l_def_bal_id := get_defined_balance_id('Employer Contribution Exemption Limit Used','_TU_MU_LU_BIMONTH') ;
1037: l_t_emp_contri_el_bimonth := pay_balance_pkg.get_value(l_def_bal_id,NULL,l_legal_employer_id,l_municipal_no,NULL,NULL,NULL,l_reporting_end_date);
1038: l_emp_contri_el_bimonth := l_t_emp_contri_el_bimonth + l_emp_contri_el_bimonth;
1039:
1040: END IF;
1041: