View: PAY_CA_EMP_PROV_TAX_INFO_D

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_CA_EMP_PROV_TAX_INFO_D

View Text

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'

Columns