View: PAY_CA_EMP_PROV_TAX_INFO_V

Product:	PAY - Payroll
Description:	View for pay_ca_emp_prov_tax_info_v
Implementation/DBA Data:	APPS.PAY_CA_EMP_PROV_TAX_INFO_V

View Text

SELECT PTI.ROWID ROW_ID
, PTI.EMP_PROVINCE_TAX_INF_ID
, PTI.EFFECTIVE_START_DATE
, PTI.EFFECTIVE_END_DATE
, PTI.LEGISLATION_CODE
, PTI.ASSIGNMENT_ID
, PTI.BUSINESS_GROUP_ID
, PTI.PROVINCE_CODE
, HRL1.MEANING PROVINCE_NAME
, PTI.JURISDICTION_CODE
, PTI.TAX_CREDIT_AMOUNT
, PTI.DEDUCTION_CODE
, PTI.EXTRA_INFO_NOT_PROVIDED
, 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.QPP_EXEMPT_FLAG
, PTI.OTHER_TAX_CREDIT
, PTI.TAX_CALC_METHOD
, HRL.MEANING CALCULATION_METHOD
, PTI.CA_TAX_INFORMATION_CATEGORY
, PTI.CA_TAX_INFORMATION1
, PTI.CA_TAX_INFORMATION2
, PTI.CA_TAX_INFORMATION3
, PTI.CA_TAX_INFORMATION4
, PTI.CA_TAX_INFORMATION5
, PTI.CA_TAX_INFORMATION6
, PTI.CA_TAX_INFORMATION7
, PTI.CA_TAX_INFORMATION8
, PTI.CA_TAX_INFORMATION9
, PTI.CA_TAX_INFORMATION10
, PTI.CA_TAX_INFORMATION11
, PTI.CA_TAX_INFORMATION12
, PTI.CA_TAX_INFORMATION13
, PTI.CA_TAX_INFORMATION14
, PTI.CA_TAX_INFORMATION15
, PTI.CA_TAX_INFORMATION16
, PTI.CA_TAX_INFORMATION17
, PTI.CA_TAX_INFORMATION18
, PTI.CA_TAX_INFORMATION19
, PTI.CA_TAX_INFORMATION20
, PTI.CA_TAX_INFORMATION21
, PTI.CA_TAX_INFORMATION22
, PTI.CA_TAX_INFORMATION23
, PTI.CA_TAX_INFORMATION24
, PTI.CA_TAX_INFORMATION25
, PTI.CA_TAX_INFORMATION26
, PTI.CA_TAX_INFORMATION27
, PTI.CA_TAX_INFORMATION28
, PTI.CA_TAX_INFORMATION29
, PTI.CA_TAX_INFORMATION30
, PTI.PROV_LSP_AMOUNT
, PTI.LAST_UPDATE_LOGIN
, PTI.CREATED_BY
, PTI.CREATION_DATE
, PTI.LAST_UPDATED_BY
, PTI.LAST_UPDATE_DATE
, PTI.OBJECT_VERSION_NUMBER
, PTI.PPIP_EXEMPT_FLAG
FROM HR_LOOKUPS HRL
, FND_SESSIONS FND
, HR_LOOKUPS HRL1
, PAY_CA_EMP_PROV_TAX_INFO_F PTI
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN PTI.EFFECTIVE_START_DATE
AND PTI.EFFECTIVE_END_DATE
AND PTI.TAX_CALC_METHOD = HRL.LOOKUP_CODE(+)
AND HRL.LOOKUP_TYPE(+) = 'CA_TAX_CALC_METHOD'
AND HRL1.LOOKUP_CODE(+) = PTI.PROVINCE_CODE
AND HRL1.LOOKUP_TYPE(+) = 'CA_PROVINCE'

Columns