DBA Data[Home] [Help]

APPS.PAY_NL_EOY_PKG dependencies on PAY_BALANCE_PKG

Line 716: l_special_rate_income_ptd :=pay_balance_pkg.get_value(p_defined_balance_id=> l_spl_rate_income_dbaid_ptd

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

Line 737: pay_balance_pkg.set_context('BALANCE_DATE',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);

Line 738: l_special_rate_income_ptd :=pay_balance_pkg.get_value(p_defined_balance_id=> l_spl_rate_income_dbaid_ptd

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

Line 751: l_special_rate_income_ptd :=pay_balance_pkg.get_value(l_spl_rate_income_dbaid_ptd

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;

Line 885: l_std_tax_income :=pay_balance_pkg.get_value(l_std_tax_dbalid

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

Line 888: l_spl_tax_income :=pay_balance_pkg.get_value(l_spl_tax_dbalid

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

Line 891: l_retrostd_tax_income :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid

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

Line 894: l_retrostdcurrq_tax_income :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid

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

Line 897: l_retrospl_tax_income :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid

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

Line 904: l_hol_allow_pay_income :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid

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

Line 907: l_hol_allow_tax_income :=pay_balance_pkg.get_value(l_hol_allow_tax_dbalid

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

Line 910: l_retrohol_allow_tax_income :=pay_balance_pkg.get_value(l_retrohol_allow_tax_dbalid

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

Line 921: l_std_tax_income_ptd :=pay_balance_pkg.get_value(l_std_tax_dbalid_ptd

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

Line 928: l_spl_tax_income_ptd :=pay_balance_pkg.get_value(l_spl_tax_dbalid_ptd

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

Line 935: l_retrostd_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid_ptd

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

Line 942: l_retrostdcurrq_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid_ptd

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

Line 949: l_retrospl_tax_income_ptd :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid_ptd

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

Line 956: l_hol_allow_pay_income_ptd :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid_ptd

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

Line 959: l_hol_allow_tax_income_ptd :=pay_balance_pkg.get_value(l_hol_allow_tax_dbalid_ptd

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

Line 962: l_rethol_allow_tax_income_ptd :=pay_balance_pkg.get_value(l_retrohol_allow_dbalid_ptd

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