How can I pull the same Calculation Components that I see on the Tax Withholding screen in a report?
I am in the process of creating a report to pull Tax Withholding card information for US employees. I need help in figuring out how I can pull the same calculation components that Oracle's Tax Withholding cards are showing on the front-end. I found a field called COMPONENT_NAME in the PAY_DIR_CARD_COMP_DEFS_VL table, but there appear to be duplicates for several calculation components.
In the below snip-it, which I pulled from PAY_DIR_CARD_COMP_DEFS_VL, there are three records for city component names, three for county component names, three for federal component names, and two for state component names. When I look at tax withholding cards on the front-end, it looks like the ones that I put in green font are being used (City Taxes, County Taxes, Federal Taxes, and State Taxes). However, in the below table, all of the rows have the same EFFECTIVE_END_DATE, so I don't know how to exclude the ones that aren't being used without hard-coding them in my data