DBA Data[Home] [Help]

APPS.PAY_US_ARCHIVE dependencies on PAY_US_SQWL_UDF

Line 94: pay_us_sqwl_udf.get_employment_code

90: 23-JAN-2004 ahanda 115.79 Modifed select stmt to get the
91: Spouse SSN for PR GRE to get the
92: last row valid for the year.
93: 04-DEC-2003 sodhingr 115.75 Correct the values being passed to
94: pay_us_sqwl_udf.get_employment_code
95: 26-NOV-2003 sodhingr 115.74 2219097 Changed package eoy_archive_data
96: and eoy_archive_gre_data to archive
97: government_employer flag and
98: changed logic to archive

Line 2785: if pay_us_sqwl_udf.chk_govt_employer(p_tax_unit_id =>l_tax_unit_id) then

2781: pay_us_archive.g_puerto_rico_gre := pay_us_archive.get_puerto_rico_info(l_tax_unit_id) ;
2782: pay_us_archive.g_1099R_transmitter_code := pay_us_archive.get_1099r_info(l_tax_unit_id) ;
2783: pay_us_archive.g_pre_tax_info := pay_us_archive.get_pre_tax_info(l_tax_unit_id,
2784: ln_business_group_id) ;
2785: if pay_us_sqwl_udf.chk_govt_employer(p_tax_unit_id =>l_tax_unit_id) then
2786: pay_us_archive.g_govt_employer := 'Y';
2787: else
2788: pay_us_archive.g_govt_employer := 'N';
2789: end if;

Line 4296: l_value_tab(1) := pay_us_sqwl_udf.get_employment_code(

4292: if pay_us_archive.g_govt_employer = 'Y' then
4293:
4294: hr_utility.trace('Goverment employer is ');
4295: l_step := 102;
4296: l_value_tab(1) := pay_us_sqwl_udf.get_employment_code(
4297: p_medicare_wh => lv_medicare_withheld,
4298: p_ss_wh => lv_ss_withheld);
4299: hr_utility.trace('lv_value is '||l_value_tab(1));
4300: