Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_CA_EMP_FED_TAX_INFO_D |
SELECT FTI.EMP_FED_TAX_INF_ID
, FTI. EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, FTI. EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, HRL1.MEANING EMPLOYMENT_PROVINCE_NAME
, FTI. TAX_CREDIT_AMOUNT TAX_CREDIT_AMOUNT
, FTI. BASIC_EXEMPTION_FLAG BASIC_EXEMPTION_FLAG
, FTI. ADDITIONAL_TAX ADDITIONAL_TAX
, FTI. ANNUAL_DEDN ANNUAL_DEDN
, FTI. TOTAL_EXPENSE_BY_COMMISSION TOTAL_EXPENSE_BY_COMMISSION
, FTI. TOTAL_REMNRTN_BY_COMMISSION TOTAL_REMNRTN_BY_COMMISSION
, FTI. PRESCRIBED_ZONE_DEDN_AMT PRESCRIBED_ZONE_DEDN_AMT
, FTI. OTHER_FEDTAX_CREDITS OTHER_FEDTAX_CREDITS
, FTI. CPP_QPP_EXEMPT_FLAG CPP_QPP_EXEMPT_FLAG
, FTI. FED_EXEMPT_FLAG FED_EXEMPT_FLAG
, FTI. EI_EXEMPT_FLAG EI_EXEMPT_FLAG
, FTI. TAX_CALC_METHOD TAX_CALC_METHOD
, HRL.MEANING CALCULATION_METHOD
, FTI. FED_OVERRIDE_AMOUNT FED_OVERRIDE_AMOUNT
, FTI. FED_OVERRIDE_RATE FED_OVERRIDE_RATE
, FTI.FED_LSF_AMOUNT
, FTI. LAST_UPDATE_DATE LAST_UPDATE_DATE
, FU.USER_NAME LAST_UPDATED_BY
FROM HR_LOOKUPS HRL
, HR_LOOKUPS HRL1
, FND_USER FU
, PAY_CA_EMP_FED_TAX_INFO_F FTI
WHERE FU.USER_ID(+) = FTI.LAST_UPDATED_BY
AND FTI.TAX_CALC_METHOD = HRL.LOOKUP_CODE(+)
AND HRL.LOOKUP_TYPE(+) = 'CA_TAX_CALC_METHOD'
AND HRL1.LOOKUP_CODE(+) = FTI.EMPLOYMENT_PROVINCE
AND HRL1.LOOKUP_TYPE(+) = 'CA_PROVINCE'