VIEW: APPS.PAY_CA_EMP_PROV_TAX_INFO_D

Source

View Text - Preformatted

SELECT PTI.EMP_PROVINCE_TAX_INF_ID EMP_PROVINCE_TAX_INF_ID ,PTI.EFFECTIVE_START_DATE EFFECTIVE_START_DATE ,PTI.EFFECTIVE_END_DATE EFFECTIVE_END_DATE ,HRL1.MEANING PROVINCE_NAME ,PTI.TAX_CREDIT_AMOUNT ,PTI. MARRIAGE_STATUS ,PTI. NO_OF_INFIRM_DEPENDANTS ,PTI. NON_RESIDENT_STATUS ,PTI. DISABILITY_STATUS ,PTI. NO_OF_DEPENDANTS ,PTI.ANNUAL_DEDN ,PTI.TOTAL_EXPENSE_BY_COMMISSION ,PTI.TOTAL_REMNRTN_BY_COMMISSION ,PTI.PRESCRIBED_ZONE_DEDN_AMT ,PTI.BASIC_EXEMPTION_FLAG ,PTI.ADDITIONAL_TAX ,PTI.PROV_OVERRIDE_RATE ,PTI.PROV_OVERRIDE_AMOUNT ,PTI.PROV_EXEMPT_FLAG ,PTI.PMED_EXEMPT_FLAG ,PTI.WC_EXEMPT_FLAG ,PTI.PROV_LSP_AMOUNT ,PTI.LAST_UPDATE_DATE ,FU.USER_NAME LAST_UPDATED_BY FROM FND_USER FU, HR_LOOKUPS HRL1, PAY_CA_EMP_PROV_TAX_INFO_F PTI WHERE FU.USER_ID(+) = PTI.LAST_UPDATED_BY AND HRL1.LOOKUP_CODE(+) = PTI.PROVINCE_CODE AND HRL1.LOOKUP_TYPE(+) = 'CA_PROVINCE'

View Text - HTML Formatted

SELECT PTI.EMP_PROVINCE_TAX_INF_ID EMP_PROVINCE_TAX_INF_ID
, PTI.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PTI.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, HRL1.MEANING PROVINCE_NAME
, PTI.TAX_CREDIT_AMOUNT
, PTI. MARRIAGE_STATUS
, PTI. NO_OF_INFIRM_DEPENDANTS
, PTI. NON_RESIDENT_STATUS
, PTI. DISABILITY_STATUS
, PTI. NO_OF_DEPENDANTS
, PTI.ANNUAL_DEDN
, PTI.TOTAL_EXPENSE_BY_COMMISSION
, PTI.TOTAL_REMNRTN_BY_COMMISSION
, PTI.PRESCRIBED_ZONE_DEDN_AMT
, PTI.BASIC_EXEMPTION_FLAG
, PTI.ADDITIONAL_TAX
, PTI.PROV_OVERRIDE_RATE
, PTI.PROV_OVERRIDE_AMOUNT
, PTI.PROV_EXEMPT_FLAG
, PTI.PMED_EXEMPT_FLAG
, PTI.WC_EXEMPT_FLAG
, PTI.PROV_LSP_AMOUNT
, PTI.LAST_UPDATE_DATE
, FU.USER_NAME LAST_UPDATED_BY
FROM FND_USER FU
, HR_LOOKUPS HRL1
, PAY_CA_EMP_PROV_TAX_INFO_F PTI
WHERE FU.USER_ID(+) = PTI.LAST_UPDATED_BY
AND HRL1.LOOKUP_CODE(+) = PTI.PROVINCE_CODE
AND HRL1.LOOKUP_TYPE(+) = 'CA_PROVINCE'