DBA Data[Home] [Help]

APPS.HR_US_W2_REP dependencies on PAY_US_COUNTY_TAX_INFO_F

Line 1417: -- Purpose: Procedure to fetch County Tax info from pay_us_county_tax_info_f table

1413: )
1414: IS
1415:
1416: --
1417: -- Purpose: Procedure to fetch County Tax info from pay_us_county_tax_info_f table
1418: -- The return values used in W2 reports for computing Boone County Taxes
1419: -- like Occupatinal and Mental Health Taxes
1420: --
1421: --

Line 1446: from PAY_US_COUNTY_TAX_INFO_F

1442: cnty_information4 mh_tax_limit,
1443: cnty_information5 occ_mh_tax_limit,
1444: cnty_information6 occ_mh_wage_limit,
1445: cnty_information7 mh_tax_wage_limit
1446: from PAY_US_COUNTY_TAX_INFO_F
1447: where jurisdiction_code = C_jurisdiction_code
1448: and (to_date('31-12-'||to_char(C_tax_year), 'DD-MM-YYYY')
1449: between effective_start_date and effective_end_date);
1450: