712: hr_utility.trace('~~VV l_type : '||l_type);
713: IF l_type = 'DE' THEN
714: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_BDATE_PTD');
715: IF l_ass_act_id is NOT NULL THEN
716: l_special_rate_income_ptd :=pay_balance_pkg.get_value(p_defined_balance_id=> l_spl_rate_income_dbaid_ptd
717: ,p_assignment_action_id => l_ass_act_id
718: ,p_tax_unit_id => NULL
719: ,p_jurisdiction_code => NULL
720: ,p_source_id => NULL
733: END IF;
734: ELSE
735: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_PTD');
736: IF l_ass_act_id is NOT NULL THEN
737: pay_balance_pkg.set_context('BALANCE_DATE',NULL);
738: l_special_rate_income_ptd :=pay_balance_pkg.get_value(p_defined_balance_id=> l_spl_rate_income_dbaid_ptd
739: ,p_assignment_action_id => l_ass_act_id
740: ,p_get_rr_route => true
741: ,p_get_rb_route => false);
734: ELSE
735: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_PTD');
736: IF l_ass_act_id is NOT NULL THEN
737: pay_balance_pkg.set_context('BALANCE_DATE',NULL);
738: l_special_rate_income_ptd :=pay_balance_pkg.get_value(p_defined_balance_id=> l_spl_rate_income_dbaid_ptd
739: ,p_assignment_action_id => l_ass_act_id
740: ,p_get_rr_route => true
741: ,p_get_rb_route => false);
742: ELSE
747: hr_utility.trace('~~VV 2');
748: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_PTD');
749: --12576775
750: IF l_current_period_end_date BETWEEN l_asg_start_date and l_asg_end_date THEN
751: l_special_rate_income_ptd :=pay_balance_pkg.get_value(l_spl_rate_income_dbaid_ptd
752: ,l_assignment.assignment_id,l_current_period_end_date);
753: ELSE
754: l_special_rate_income_ptd :=0;
755: END IF;
881: --if g_debug then
882: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid'||l_std_tax_dbalid,2510);
883: --end if;
884:
885: l_std_tax_income :=pay_balance_pkg.get_value(l_std_tax_dbalid
886: ,l_assignment_id
887: ,l_prev_year_end_date);
888: l_spl_tax_income :=pay_balance_pkg.get_value(l_spl_tax_dbalid
889: ,l_assignment_id
884:
885: l_std_tax_income :=pay_balance_pkg.get_value(l_std_tax_dbalid
886: ,l_assignment_id
887: ,l_prev_year_end_date);
888: l_spl_tax_income :=pay_balance_pkg.get_value(l_spl_tax_dbalid
889: ,l_assignment_id
890: ,l_prev_year_end_date);
891: l_retrostd_tax_income :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid
892: ,l_assignment_id
887: ,l_prev_year_end_date);
888: l_spl_tax_income :=pay_balance_pkg.get_value(l_spl_tax_dbalid
889: ,l_assignment_id
890: ,l_prev_year_end_date);
891: l_retrostd_tax_income :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid
892: ,l_assignment_id
893: ,l_prev_year_end_date);
894: l_retrostdcurrq_tax_income :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid
895: ,l_assignment_id
890: ,l_prev_year_end_date);
891: l_retrostd_tax_income :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid
892: ,l_assignment_id
893: ,l_prev_year_end_date);
894: l_retrostdcurrq_tax_income :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid
895: ,l_assignment_id
896: ,l_prev_year_end_date);
897: l_retrospl_tax_income :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid
898: ,l_assignment_id
893: ,l_prev_year_end_date);
894: l_retrostdcurrq_tax_income :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid
895: ,l_assignment_id
896: ,l_prev_year_end_date);
897: l_retrospl_tax_income :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid
898: ,l_assignment_id
899: ,l_prev_year_end_date);
900: --if g_debug then
901: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income'||l_retrospl_tax_income,2520);
900: --if g_debug then
901: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income'||l_retrospl_tax_income,2520);
902: --end if;
903:
904: l_hol_allow_pay_income :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid
905: ,l_assignment_id
906: ,l_prev_year_end_date);
907: l_hol_allow_tax_income :=pay_balance_pkg.get_value(l_hol_allow_tax_dbalid
908: ,l_assignment_id
903:
904: l_hol_allow_pay_income :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid
905: ,l_assignment_id
906: ,l_prev_year_end_date);
907: l_hol_allow_tax_income :=pay_balance_pkg.get_value(l_hol_allow_tax_dbalid
908: ,l_assignment_id
909: ,l_prev_year_end_date);
910: l_retrohol_allow_tax_income :=pay_balance_pkg.get_value(l_retrohol_allow_tax_dbalid
911: ,l_assignment_id
906: ,l_prev_year_end_date);
907: l_hol_allow_tax_income :=pay_balance_pkg.get_value(l_hol_allow_tax_dbalid
908: ,l_assignment_id
909: ,l_prev_year_end_date);
910: l_retrohol_allow_tax_income :=pay_balance_pkg.get_value(l_retrohol_allow_tax_dbalid
911: ,l_assignment_id
912: ,l_prev_year_end_date);
913:
914: --if g_debug then
917: hr_utility.set_location('Inside get_balance_values: l_period_end_date'||l_period_end_date,2530);
918: --end if;
919:
920:
921: l_std_tax_income_ptd :=pay_balance_pkg.get_value(l_std_tax_dbalid_ptd
922: ,l_assignment_id
923: ,l_period_end_date);
924: --if g_debug then
925: hr_utility.set_location('Inside get_balance_values: l_std_tax_income_ptd'||l_std_tax_income_ptd,2531);
924: --if g_debug then
925: hr_utility.set_location('Inside get_balance_values: l_std_tax_income_ptd'||l_std_tax_income_ptd,2531);
926: --end if;
927:
928: l_spl_tax_income_ptd :=pay_balance_pkg.get_value(l_spl_tax_dbalid_ptd
929: ,l_assignment_id
930: ,l_period_end_date);
931: --if g_debug then
932: hr_utility.set_location('Inside get_balance_values: l_spl_tax_income_ptd'||l_spl_tax_income_ptd,2532);
931: --if g_debug then
932: hr_utility.set_location('Inside get_balance_values: l_spl_tax_income_ptd'||l_spl_tax_income_ptd,2532);
933: --end if;
934:
935: l_retrostd_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid_ptd
936: ,l_assignment_id
937: ,l_period_end_date);
938: --if g_debug then
939: hr_utility.set_location('Inside get_balance_values: l_retrostd_tax_income_ptd'||l_retrostd_tax_income_ptd,2533);
938: --if g_debug then
939: hr_utility.set_location('Inside get_balance_values: l_retrostd_tax_income_ptd'||l_retrostd_tax_income_ptd,2533);
940: --end if;
941:
942: l_retrostdcurrq_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid_ptd
943: ,l_assignment_id
944: ,l_period_end_date);
945: --if g_debug then
946: hr_utility.set_location('Inside get_balance_values: l_retrostdcurrq_tax_income_ptd'||l_retrostdcurrq_tax_income_ptd,2534);
945: --if g_debug then
946: hr_utility.set_location('Inside get_balance_values: l_retrostdcurrq_tax_income_ptd'||l_retrostdcurrq_tax_income_ptd,2534);
947: --end if;
948:
949: l_retrospl_tax_income_ptd :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid_ptd
950: ,l_assignment_id
951: ,l_period_end_date);
952: --if g_debug then
953: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income_ptd'||l_retrospl_tax_income_ptd,2540);
952: --if g_debug then
953: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income_ptd'||l_retrospl_tax_income_ptd,2540);
954: --end if;
955:
956: l_hol_allow_pay_income_ptd :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid_ptd
957: ,l_assignment_id
958: ,l_period_end_date);
959: l_hol_allow_tax_income_ptd :=pay_balance_pkg.get_value(l_hol_allow_tax_dbalid_ptd
960: ,l_assignment_id
955:
956: l_hol_allow_pay_income_ptd :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid_ptd
957: ,l_assignment_id
958: ,l_period_end_date);
959: l_hol_allow_tax_income_ptd :=pay_balance_pkg.get_value(l_hol_allow_tax_dbalid_ptd
960: ,l_assignment_id
961: ,l_period_end_date);
962: l_rethol_allow_tax_income_ptd :=pay_balance_pkg.get_value(l_retrohol_allow_dbalid_ptd
963: ,l_assignment_id
958: ,l_period_end_date);
959: l_hol_allow_tax_income_ptd :=pay_balance_pkg.get_value(l_hol_allow_tax_dbalid_ptd
960: ,l_assignment_id
961: ,l_period_end_date);
962: l_rethol_allow_tax_income_ptd :=pay_balance_pkg.get_value(l_retrohol_allow_dbalid_ptd
963: ,l_assignment_id
964: ,l_period_end_date);
965: --if g_debug then
966: hr_utility.set_location('Inside get_balance_values: l_rethol_allow_tax_income_ptd'||l_rethol_allow_tax_income_ptd,2550);