DBA Data[Home] [Help]

APPS.PAY_US_MMRF_W2_FORMAT_RECORD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 2794

SELECT SS_EE_WAGE_LIMIT*100,
       (SS_EE_WAGE_LIMIT*SS_EE_RATE)*100 tax
FROM   PAY_US_FEDERAL_TAX_INFO_F
WHERE  TO_DATE(C_DATE,'DD-MM-YYYY') BETWEEN EFFECTIVE_START_DATE
                                        AND EFFECTIVE_END_DATE
AND    FED_INFORMATION_CATEGORY = '401K LIMITS';