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_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 870: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_total_earnings)||''

866: lv_format := ''||get_lookup_meaning('L_SIN')||
867: ''|| ''||sv_employee_sin||''||
868: ''||get_lookup_meaning('L_TOT_EARN')||
869: ''|| ''
870: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_total_earnings)||''
871: || ' '|| ' ';
872: format_data(lv_format);
873:
874: lv_format := ''||get_lookup_meaning('L_DOB')||

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

876: if sv_f_p = 'F' then
877: lv_format := lv_format ||
878: ''||get_lookup_meaning('L_CPP_PENS_EARN')
879: ||''|| ''
880: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_pensionable_earnings)
881: ||'';
882:
883: else
884: lv_format := lv_format ||

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

883: else
884: lv_format := lv_format ||
885: ''||get_lookup_meaning('L_QPP_PENS_EARN')
886: ||''|| ''
887: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_pensionable_earnings)||
888: '';
889: end if;
890:
891: if ( sv_f_p = 'F' ) then

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

891: if ( sv_f_p = 'F' ) then
892: lv_format := lv_format || ''||
893: get_lookup_meaning('L_INS_EARN')||''||
894: ''||
895: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_insurable_earnings)||'';
896: else
897: lv_format := lv_format || ''||
898: get_lookup_meaning('L_PPIP_INSEARN')||''||
899: ''||

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

896: else
897: lv_format := lv_format || ''||
898: get_lookup_meaning('L_PPIP_INSEARN')||''||
899: ''||
900: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_insurable_earnings)||'';
901: end if;
902: format_data(lv_format);
903:
904: lv_format := ''||

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

908: if sv_f_p = 'F' then
909: lv_format := lv_format || ''||
910: get_lookup_meaning('L_CPP_REPORTED')||''||
911: ''
912: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||
913: ''||get_lookup_meaning('L_EI_REPORTED')
914: ||''|| ''
915: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_18)||'';
916: else

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

911: ''
912: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||
913: ''||get_lookup_meaning('L_EI_REPORTED')
914: ||''|| ''
915: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_18)||'';
916: else
917: lv_format := lv_format || ''||
918: get_lookup_meaning('L_QPP_REPORTED')||''||
919: ''||

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

916: else
917: lv_format := lv_format || ''||
918: get_lookup_meaning('L_QPP_REPORTED')||''||
919: ''||
920: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||
921: ''||get_lookup_meaning('L_PPIP_REPORTED')
922: ||''|| ''
923: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_ppip)||
924: '';

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

919: ''||
920: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_16)||''||
921: ''||get_lookup_meaning('L_PPIP_REPORTED')
922: ||''|| ''
923: ||pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ded_reported_ppip)||
924: '';
925: end if;
926: format_data(lv_format);
927:

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

932: if sv_f_p = 'F' then
933: lv_format := lv_format || ''||
934: get_lookup_meaning('L_CPP_REQUIRED')||''||
935: ''||
936: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||
937: ''||get_lookup_meaning('L_EI_REQUIRED')
938: ||''|| ''||
939: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_ded_required)||'';
940: else

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

935: ''||
936: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||
937: ''||get_lookup_meaning('L_EI_REQUIRED')
938: ||''|| ''||
939: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_ded_required)||'';
940: else
941: lv_format := lv_format || ''||
942: get_lookup_meaning('L_QPP_REQUIRED')||''||
943: ''||

Line 945: /*pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||*/

941: lv_format := lv_format || ''||
942: get_lookup_meaning('L_QPP_REQUIRED')||''||
943: ''||
944: /*For Bug no. 13421306- Changed sv_cpp_ded_required to sv_qpp_ded_required*/
945: /*pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||*/
946: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qpp_ded_required)||''||
947: ''||get_lookup_meaning('L_PPIP_REQUIRED')
948: ||''|| ''||
949: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_ded_required)||

Line 946: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qpp_ded_required)||''||

942: get_lookup_meaning('L_QPP_REQUIRED')||''||
943: ''||
944: /*For Bug no. 13421306- Changed sv_cpp_ded_required to sv_qpp_ded_required*/
945: /*pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||*/
946: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qpp_ded_required)||''||
947: ''||get_lookup_meaning('L_PPIP_REQUIRED')
948: ||''|| ''||
949: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_ded_required)||
950: '';

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

945: /*pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_ded_required)||''||*/
946: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qpp_ded_required)||''||
947: ''||get_lookup_meaning('L_PPIP_REQUIRED')
948: ||''|| ''||
949: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_ded_required)||
950: '';
951: end if;
952: format_data(lv_format);
953:

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

958: ' '||''||
959: ''||
960: get_lookup_meaning('L_CPP_DEFICIENCY')||''||
961: ''||
962: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||
963: ''||
964: get_lookup_meaning('L_EI_DEFICIENCY')||''||
965: ''||
966: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_deficiency)||'';

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

962: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||
963: ''||
964: get_lookup_meaning('L_EI_DEFICIENCY')||''||
965: ''||
966: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ei_deficiency)||'';
967: --''||sv_no_of_cpp_periods||''||
968: else
969: lv_format := ''||
970: get_lookup_meaning('L_RL_SLIP_NO')||''||

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

972: sv_rl1_slip_no ||''||
973: ''||
974: get_lookup_meaning('L_QPP_DEFICIENCY')||''||
975: ''||
976: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||
977: ''||
978: get_lookup_meaning('L_PPIP_DEFICIENCY')||''||
979: ''||
980: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_deficiency)||

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

976: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_qpp_deficiency)||''||
977: ''||
978: get_lookup_meaning('L_PPIP_DEFICIENCY')||''||
979: ''||
980: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_ppip_deficiency)||
981: '';
982: --''||sv_no_of_cpp_periods||''||
983: end if;
984: format_data(lv_format);

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

986: if sv_f_p = 'F' then
987: lv_format := ''||
988: get_lookup_meaning('L_CPP_BASIC_EXEMPT')||''||
989: ''||
990: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
991: ''||
992: get_lookup_meaning('L_CPP_EXEMPT')||''||
993: ''||
994: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||''||

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

990: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
991: ''||
992: get_lookup_meaning('L_CPP_EXEMPT')||''||
993: ''||
994: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||''||
995: /* bug 5552744 */
996: /* QC Insurable Earning */
997: ''||
998: get_lookup_meaning('L_INS_EARN')||' (QC)'||''||

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

996: /* QC Insurable Earning */
997: ''||
998: get_lookup_meaning('L_INS_EARN')||' (QC)'||''||
999: ''||
1000: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_insurable_earnings)||''||
1001: /* QC EI Reported */
1002: ''||
1003: ' ' ||''||
1004: ''||

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

1009: ' '||''||
1010: ''||
1011: get_lookup_meaning('L_EI_REPORTED')||' (QC)'||''||
1012: ''||
1013: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_ded_reported_18)||''||
1014: /* QC EI Required */
1015: ''||
1016: ' ' ||''||
1017: ''||

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

1022: ' '||''||
1023: ''||
1024: get_lookup_meaning('L_EI_REQUIRED')||' (QC)'||''||
1025: ''||
1026: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_ei_ded_required)||''||
1027: /* QC EI Deficiency */
1028: ''||
1029: ' ' ||''||
1030: ''||

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

1035: ' '||''||
1036: ''||
1037: get_lookup_meaning('L_EI_DEFICIENCY')||' (QC)'||''||
1038: ''||
1039: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_qc_ei_deficiency)||'';
1040:
1041: else
1042: lv_format := ''||
1043: get_lookup_meaning('L_QPP_BASIC_EXEMPT')||''||

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

1041: else
1042: lv_format := ''||
1043: get_lookup_meaning('L_QPP_BASIC_EXEMPT')||''||
1044: ''||
1045: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
1046: ''||
1047: get_lookup_meaning('L_QPP_EXEMPT')||''||
1048: ''||
1049: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||'';

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

1045: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_basic_exemption)||''||
1046: ''||
1047: get_lookup_meaning('L_QPP_EXEMPT')||''||
1048: ''||
1049: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,sv_cpp_exempt_bal)||'';
1050: end if;
1051: format_data(lv_format);
1052:
1053: end if; -- End of sv_report_type = 'T4A'

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

1639:
1640: sv_nb := sv_nb + 1;
1641: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1642: sv_neg_bal(sv_nb).dbi_value :=
1643: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
1644: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
1645: sv_print := 1;
1646:
1647: end if;

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

1651:
1652: sv_nb := sv_nb + 1;
1653: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
1654: sv_neg_bal(sv_nb).dbi_value :=
1655: pay_us_employee_payslip_web.get_format_value(sv_b_g_id,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
1656: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
1657: sv_print := 1;
1658:
1659: end if;

Line 1922: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1918:
1919: sv_nb := sv_nb + 1;
1920: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_A';
1921: sv_neg_bal(sv_nb).dbi_value :=
1922: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1923: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_A));
1924:
1925: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box A';
1926: sv_print := 1;

Line 1934: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1930:
1931: sv_nb := sv_nb + 1;
1932: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_B';
1933: sv_neg_bal(sv_nb).dbi_value :=
1934: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1935: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_B));
1936:
1937: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box B';
1938: sv_print := 1;

Line 1946: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1942:
1943: sv_nb := sv_nb + 1;
1944: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_C';
1945: sv_neg_bal(sv_nb).dbi_value :=
1946: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1947: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_C));
1948:
1949: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box C';
1950: sv_print := 1;

Line 1958: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1954:
1955: sv_nb := sv_nb + 1;
1956: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_D';
1957: sv_neg_bal(sv_nb).dbi_value :=
1958: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1959: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_D));
1960:
1961: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box D';
1962: sv_print := 1;

Line 1970: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1966:
1967: sv_nb := sv_nb + 1;
1968: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_E';
1969: sv_neg_bal(sv_nb).dbi_value :=
1970: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1971: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_E));
1972:
1973: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box E';
1974: sv_print := 1;

Line 1982: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1978:
1979: sv_nb := sv_nb + 1;
1980: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_F';
1981: sv_neg_bal(sv_nb).dbi_value :=
1982: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1983: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_F));
1984:
1985: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box F';
1986: sv_print := 1;

Line 1994: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

1990:
1991: sv_nb := sv_nb + 1;
1992: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_G';
1993: sv_neg_bal(sv_nb).dbi_value :=
1994: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
1995: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_G));
1996:
1997: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box G';
1998: sv_print := 1;

Line 2006: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2002:
2003: sv_nb := sv_nb + 1;
2004: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_H';
2005: sv_neg_bal(sv_nb).dbi_value :=
2006: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2007: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_H));
2008:
2009: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box H';
2010: sv_print := 1;

Line 2018: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2014:
2015: sv_nb := sv_nb + 1;
2016: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_I';
2017: sv_neg_bal(sv_nb).dbi_value :=
2018: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2019: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_I));
2020:
2021: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box I';
2022: sv_print := 1;

Line 2030: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2026:
2027: sv_nb := sv_nb + 1;
2028: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_J';
2029: sv_neg_bal(sv_nb).dbi_value :=
2030: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2031: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_J));
2032:
2033: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box J';
2034: sv_print := 1;

Line 2042: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2038:
2039: sv_nb := sv_nb + 1;
2040: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_K';
2041: sv_neg_bal(sv_nb).dbi_value :=
2042: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2043: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_K));
2044:
2045: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box K';
2046: sv_print := 1;

Line 2054: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2050:
2051: sv_nb := sv_nb + 1;
2052: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_L';
2053: sv_neg_bal(sv_nb).dbi_value :=
2054: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2055: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_L));
2056:
2057: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box L';
2058: sv_print := 1;

Line 2066: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2062:
2063: sv_nb := sv_nb + 1;
2064: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_M';
2065: sv_neg_bal(sv_nb).dbi_value :=
2066: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2067: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_M));
2068:
2069: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box M';
2070: sv_print := 1;

Line 2078: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2074:
2075: sv_nb := sv_nb + 1;
2076: sv_neg_bal(sv_nb).dbi_name := 'RL2_BOX_O';
2077: sv_neg_bal(sv_nb).dbi_value :=
2078: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2079: ,fnd_number.canonical_to_number(lr_rl2_emprec.RL2_BOX_O));
2080:
2081: sv_neg_bal(sv_nb).dbi_short_name := 'RL2 Box O';
2082: sv_print := 1;

Line 2093: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2089: if (fnd_number.canonical_to_number(nvl(l_further_amount(l_i),'0')) < 0) then
2090: sv_nb := sv_nb + 1;
2091: sv_neg_bal(sv_nb).dbi_name := l_further_code(l_i);
2092: sv_neg_bal(sv_nb).dbi_value :=
2093: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2094: ,l_further_amount(l_i));
2095: sv_neg_bal(sv_nb).dbi_short_name := l_further_short_name(l_i);
2096: sv_print := 1;
2097: end if;

Line 2760: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2756: else
2757: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2758: end if;
2759: sv_neg_bal(sv_nb).dbi_value :=
2760: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2761: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
2762: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
2763: sv_print := 1;
2764: end if;

Line 2772: pay_us_employee_payslip_web.get_format_value(sv_b_g_id

2768:
2769: sv_nb := sv_nb + 1;
2770: sv_neg_bal(sv_nb).dbi_name := sv_dbi(i).dbi_name;
2771: sv_neg_bal(sv_nb).dbi_value :=
2772: pay_us_employee_payslip_web.get_format_value(sv_b_g_id
2773: ,fnd_number.canonical_to_number(sv_dbi(i).dbi_value));
2774: sv_neg_bal(sv_nb).dbi_short_name := sv_dbi(i).dbi_short_name;
2775: sv_print := 1;
2776: