VIEW: APPS.PAY_CA_EMP_FED_TAX_INFO_D

Source

View Text - Preformatted

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.CPP_ELECTION_DATE CPP_ELECTION_DATE, FTI.CPP_REVOCATION_DATE CPP_REVOCATION_DATE, 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'

View Text - HTML Formatted

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.CPP_ELECTION_DATE CPP_ELECTION_DATE
, FTI.CPP_REVOCATION_DATE CPP_REVOCATION_DATE
, 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'