DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on PAY_US_EMPLOYEE_PAYSLIP_WEB

Line 109: pay_us_employee_payslip_web.get_format_value instead of

105: 31-JUL-2006 ydevi 115.39 all monetary values are converted into number by using
106: fnd_number.number_to_canonical function instead of to_number
107: function
108: The masking of the monetory values has been done using
109: pay_us_employee_payslip_web.get_format_value instead of
110: to_char.
111: 01-Aug-2006 ssmukher 115.40 Implementation of PPIP tax in the package.Also the
112: use of diff EI rates (For Quebec and Non Quebec Employees).
113: Modified the following procedures

Line 711: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_total_earnings)||''

707: lv_format := ''||get_lookup_meaning('L_SIN')||
708: '
'|| ''||sv_employee_sin||''||
709: ''||get_lookup_meaning('L_TOT_EARN')||
710: '
'|| ''
711: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_total_earnings)||''
712: || ' '|| ' ';
713: format_data(lv_format);
714:
715: lv_format := ''||get_lookup_meaning('L_DOB')||

Line 721: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_pensionable_earnings)

717: if sv_f_p = 'F' then
718: lv_format := lv_format ||
719: ''||get_lookup_meaning('L_CPP_PENS_EARN')
720: ||'
'|| ''
721: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_pensionable_earnings)
722: ||'';
723:
724: else
725: lv_format := lv_format ||

Line 728: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_pensionable_earnings)||

724: else
725: lv_format := lv_format ||
726: ''||get_lookup_meaning('L_QPP_PENS_EARN')
727: ||'
'|| ''
728: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_pensionable_earnings)||
729: '';
730: end if;
731:
732: if ( sv_f_p = 'F' ) then

Line 736: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_insurable_earnings)||'';

732: if ( sv_f_p = 'F' ) then
733: lv_format := lv_format || ''||
734: get_lookup_meaning('L_INS_EARN')||'
'||
735: ''||
736: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_insurable_earnings)||'';
737: else
738: lv_format := lv_format || ''||
739: get_lookup_meaning('L_PPIP_INSEARN')||'
'||
740: ''||

Line 741: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_insurable_earnings)||'';

737: else
738: lv_format := lv_format || ''||
739: get_lookup_meaning('L_PPIP_INSEARN')||'
'||
740: ''||
741: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_insurable_earnings)||'';
742: end if;
743: format_data(lv_format);
744:
745: lv_format := ''||

Line 753: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||

749: if sv_f_p = 'F' then
750: lv_format := lv_format || ''||
751: get_lookup_meaning('L_CPP_REPORTED')||'
'||
752: ''
753: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||
754: ''||get_lookup_meaning('L_EI_REPORTED')
755: ||'
'|| ''
756: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_18)||'';
757: else

Line 756: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_18)||'';

752: ''
753: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||
754: ''||get_lookup_meaning('L_EI_REPORTED')
755: ||'
'|| ''
756: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_18)||'';
757: else
758: lv_format := lv_format || ''||
759: get_lookup_meaning('L_QPP_REPORTED')||'
'||
760: ''||

Line 761: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||

757: else
758: lv_format := lv_format || ''||
759: get_lookup_meaning('L_QPP_REPORTED')||'
'||
760: ''||
761: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||
762: ''||get_lookup_meaning('L_PPIP_REPORTED')
763: ||'
'|| ''
764: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_ppip)||
765: '';

Line 764: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_ppip)||

760: ''||
761: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||
762: ''||get_lookup_meaning('L_PPIP_REPORTED')
763: ||'
'|| ''
764: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_ppip)||
765: '';
766: end if;
767: format_data(lv_format);
768:

Line 777: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||

773: if sv_f_p = 'F' then
774: lv_format := lv_format || ''||
775: get_lookup_meaning('L_CPP_REQUIRED')||'
'||
776: ''||
777: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||
778: ''||get_lookup_meaning('L_EI_REQUIRED')
779: ||'
'|| ''||
780: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_ded_required)||'';
781: else

Line 780: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_ded_required)||'';

776: ''||
777: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||
778: ''||get_lookup_meaning('L_EI_REQUIRED')
779: ||'
'|| ''||
780: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_ded_required)||'';
781: else
782: lv_format := lv_format || ''||
783: get_lookup_meaning('L_QPP_REQUIRED')||'
'||
784: ''||

Line 785: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||

781: else
782: lv_format := lv_format || ''||
783: get_lookup_meaning('L_QPP_REQUIRED')||'
'||
784: ''||
785: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||
786: ''||get_lookup_meaning('L_PPIP_REQUIRED')
787: ||'
'|| ''||
788: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_ded_required)||
789: '';

Line 788: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_ded_required)||

784: ''||
785: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||
786: ''||get_lookup_meaning('L_PPIP_REQUIRED')
787: ||'
'|| ''||
788: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_ded_required)||
789: '';
790: end if;
791: format_data(lv_format);
792:

Line 801: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||

797: ' '||''||
798: ''||
799: get_lookup_meaning('L_CPP_DEFICIENCY')||'
'||
800: ''||
801: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||
802: ''||
803: get_lookup_meaning('L_EI_DEFICIENCY')||'
'||
804: ''||
805: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_deficiency)||'';

Line 805: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_deficiency)||'';

801: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||
802: ''||
803: get_lookup_meaning('L_EI_DEFICIENCY')||'
'||
804: ''||
805: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_deficiency)||'';
806: --''||sv_no_of_cpp_periods||''||
807: else
808: lv_format := ''||
809: get_lookup_meaning('L_RL_SLIP_NO')||'
'||

Line 815: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||

811: sv_rl1_slip_no ||''||
812: ''||
813: get_lookup_meaning('L_QPP_DEFICIENCY')||'
'||
814: ''||
815: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||
816: ''||
817: get_lookup_meaning('L_PPIP_DEFICIENCY')||'
'||
818: ''||
819: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_deficiency)||

Line 819: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_deficiency)||

815: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||
816: ''||
817: get_lookup_meaning('L_PPIP_DEFICIENCY')||'
'||
818: ''||
819: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_deficiency)||
820: '';
821: --''||sv_no_of_cpp_periods||''||
822: end if;
823: format_data(lv_format);

Line 829: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||

825: if sv_f_p = 'F' then
826: lv_format := ''||
827: get_lookup_meaning('L_CPP_BASIC_EXEMPT')||'
'||
828: ''||
829: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
830: ''||
831: get_lookup_meaning('L_CPP_EXEMPT')||'
'||
832: ''||
833: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||''||

Line 833: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||''||

829: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
830: ''||
831: get_lookup_meaning('L_CPP_EXEMPT')||'
'||
832: ''||
833: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||''||
834: /* bug 5552744 */
835: /* QC Insurable Earning */
836: ''||
837: get_lookup_meaning('L_INS_EARN')||' (QC)'||'
'||

Line 839: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_insurable_earnings)||''||

835: /* QC Insurable Earning */
836: ''||
837: get_lookup_meaning('L_INS_EARN')||' (QC)'||'
'||
838: ''||
839: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_insurable_earnings)||''||
840: /* QC EI Reported */
841: ''||
842: ' ' ||'
'||
843: ''||

Line 852: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_ded_reported_18)||''||

848: ' '||''||
849: ''||
850: get_lookup_meaning('L_EI_REPORTED')||' (QC)'||'
'||
851: ''||
852: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_ded_reported_18)||''||
853: /* QC EI Required */
854: ''||
855: ' ' ||'
'||
856: ''||

Line 865: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_ei_ded_required)||''||

861: ' '||''||
862: ''||
863: get_lookup_meaning('L_EI_REQUIRED')||' (QC)'||'
'||
864: ''||
865: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_ei_ded_required)||''||
866: /* QC EI Deficiency */
867: ''||
868: ' ' ||'
'||
869: ''||

Line 878: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_ei_deficiency)||'';

874: ' '||''||
875: ''||
876: get_lookup_meaning('L_EI_DEFICIENCY')||' (QC)'||'
'||
877: ''||
878: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_ei_deficiency)||'';
879:
880: else
881: lv_format := ''||
882: get_lookup_meaning('L_QPP_BASIC_EXEMPT')||'
'||

Line 884: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||

880: else
881: lv_format := ''||
882: get_lookup_meaning('L_QPP_BASIC_EXEMPT')||'
'||
883: ''||
884: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
885: ''||
886: get_lookup_meaning('L_QPP_EXEMPT')||'
'||
887: ''||
888: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||'';

Line 888: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||'';

884: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
885: ''||
886: get_lookup_meaning('L_QPP_EXEMPT')||'
'||
887: ''||
888: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||'';
889: end if;
890: format_data(lv_format);
891:
892: end if; -- End of sv_report_type = 'T4A'

Line 1433: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));

1429:
1430: sv_nb := sv_nb + 1;
1431: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1432: sv_neg_bal(sv_nb).dbi_value :=
1433: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
1434: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
1435: sv_print := 1;
1436:
1437: end if;

Line 1445: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));

1441:
1442: sv_nb := sv_nb + 1;
1443: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1444: sv_neg_bal(sv_nb).dbi_value :=
1445: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
1446: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
1447: sv_print := 1;
1448:
1449: end if;

Line 1664: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1660:
1661: sv_nb := sv_nb + 1;
1662: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_A';
1663: sv_neg_bal(sv_nb).dbi_value :=
1664: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1665: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_A));
1666:
1667: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box A';
1668: sv_print := 1;

Line 1676: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1672:
1673: sv_nb := sv_nb + 1;
1674: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_B';
1675: sv_neg_bal(sv_nb).dbi_value :=
1676: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1677: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_B));
1678:
1679: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box B';
1680: sv_print := 1;

Line 1688: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1684:
1685: sv_nb := sv_nb + 1;
1686: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_C';
1687: sv_neg_bal(sv_nb).dbi_value :=
1688: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1689: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_C));
1690:
1691: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box C';
1692: sv_print := 1;

Line 1700: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1696:
1697: sv_nb := sv_nb + 1;
1698: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_D';
1699: sv_neg_bal(sv_nb).dbi_value :=
1700: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1701: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_D));
1702:
1703: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box D';
1704: sv_print := 1;

Line 1712: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1708:
1709: sv_nb := sv_nb + 1;
1710: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_E';
1711: sv_neg_bal(sv_nb).dbi_value :=
1712: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1713: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_E));
1714:
1715: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box E';
1716: sv_print := 1;

Line 1724: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1720:
1721: sv_nb := sv_nb + 1;
1722: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_F';
1723: sv_neg_bal(sv_nb).dbi_value :=
1724: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1725: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_F));
1726:
1727: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box F';
1728: sv_print := 1;

Line 1736: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1732:
1733: sv_nb := sv_nb + 1;
1734: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_G';
1735: sv_neg_bal(sv_nb).dbi_value :=
1736: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1737: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_G));
1738:
1739: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box G';
1740: sv_print := 1;

Line 1748: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1744:
1745: sv_nb := sv_nb + 1;
1746: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_H';
1747: sv_neg_bal(sv_nb).dbi_value :=
1748: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1749: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_H));
1750:
1751: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box H';
1752: sv_print := 1;

Line 1760: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1756:
1757: sv_nb := sv_nb + 1;
1758: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_I';
1759: sv_neg_bal(sv_nb).dbi_value :=
1760: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1761: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_I));
1762:
1763: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box I';
1764: sv_print := 1;

Line 1772: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1768:
1769: sv_nb := sv_nb + 1;
1770: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_J';
1771: sv_neg_bal(sv_nb).dbi_value :=
1772: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1773: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_J));
1774:
1775: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box J';
1776: sv_print := 1;

Line 1784: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1780:
1781: sv_nb := sv_nb + 1;
1782: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_K';
1783: sv_neg_bal(sv_nb).dbi_value :=
1784: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1785: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_K));
1786:
1787: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box K';
1788: sv_print := 1;

Line 1796: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1792:
1793: sv_nb := sv_nb + 1;
1794: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_L';
1795: sv_neg_bal(sv_nb).dbi_value :=
1796: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1797: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_L));
1798:
1799: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box L';
1800: sv_print := 1;

Line 1808: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1804:
1805: sv_nb := sv_nb + 1;
1806: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_M';
1807: sv_neg_bal(sv_nb).dbi_value :=
1808: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1809: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_M));
1810:
1811: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box M';
1812: sv_print := 1;

Line 1820: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1816:
1817: sv_nb := sv_nb + 1;
1818: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_O';
1819: sv_neg_bal(sv_nb).dbi_value :=
1820: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1821: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_O));
1822:
1823: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box O';
1824: sv_print := 1;

Line 2435: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2431: else
2432: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2433: end if;
2434: sv_neg_bal(sv_nb).dbi_value :=
2435: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2436: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
2437: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
2438: sv_print := 1;
2439: end if;

Line 2447: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2443:
2444: sv_nb := sv_nb + 1;
2445: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2446: sv_neg_bal(sv_nb).dbi_value :=
2447: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2448: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
2449: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
2450: sv_print := 1;
2451: