eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.PAY_CA_EMP_PROV_TAX_INFO_F#

Source

View Text - Preformatted


select EMP_PROVINCE_TAX_INF_ID EMP_PROVINCE_TAX_INF_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, LEGISLATION_CODE LEGISLATION_CODE, ASSIGNMENT_ID ASSIGNMENT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PROVINCE_CODE PROVINCE_CODE, JURISDICTION_CODE JURISDICTION_CODE, TAX_CREDIT_AMOUNT TAX_CREDIT_AMOUNT, BASIC_EXEMPTION_FLAG BASIC_EXEMPTION_FLAG, DEDUCTION_CODE DEDUCTION_CODE, MARRIAGE_STATUS MARRIAGE_STATUS, NO_OF_INFIRM_DEPENDANTS NO_OF_INFIRM_DEPENDANTS, NON_RESIDENT_STATUS NON_RESIDENT_STATUS, DISABILITY_STATUS DISABILITY_STATUS, NO_OF_DEPENDANTS NO_OF_DEPENDANTS, ANNUAL_DEDN ANNUAL_DEDN, TOTAL_EXPENSE_BY_COMMISSION TOTAL_EXPENSE_BY_COMMISSION, TOTAL_REMNRTN_BY_COMMISSION TOTAL_REMNRTN_BY_COMMISSION, PRESCRIBED_ZONE_DEDN_AMT PRESCRIBED_ZONE_DEDN_AMT, ADDITIONAL_TAX ADDITIONAL_TAX, PROV_OVERRIDE_RATE PROV_OVERRIDE_RATE, PROV_OVERRIDE_AMOUNT PROV_OVERRIDE_AMOUNT, PROV_EXEMPT_FLAG PROV_EXEMPT_FLAG, PMED_EXEMPT_FLAG PMED_EXEMPT_FLAG, WC_EXEMPT_FLAG WC_EXEMPT_FLAG, QPP_EXEMPT_FLAG QPP_EXEMPT_FLAG, OTHER_TAX_CREDIT OTHER_TAX_CREDIT, TAX_CALC_METHOD TAX_CALC_METHOD, EXTRA_INFO_NOT_PROVIDED EXTRA_INFO_NOT_PROVIDED, CA_TAX_INFORMATION_CATEGORY CA_TAX_INFORMATION_CATEGORY, CA_TAX_INFORMATION1 CA_TAX_INFORMATION1, CA_TAX_INFORMATION2 CA_TAX_INFORMATION2, CA_TAX_INFORMATION3 CA_TAX_INFORMATION3, CA_TAX_INFORMATION4 CA_TAX_INFORMATION4, CA_TAX_INFORMATION5 CA_TAX_INFORMATION5, CA_TAX_INFORMATION6 CA_TAX_INFORMATION6, CA_TAX_INFORMATION7 CA_TAX_INFORMATION7, CA_TAX_INFORMATION8 CA_TAX_INFORMATION8, CA_TAX_INFORMATION9 CA_TAX_INFORMATION9, CA_TAX_INFORMATION10 CA_TAX_INFORMATION10, CA_TAX_INFORMATION11 CA_TAX_INFORMATION11, CA_TAX_INFORMATION12 CA_TAX_INFORMATION12, CA_TAX_INFORMATION13 CA_TAX_INFORMATION13, CA_TAX_INFORMATION14 CA_TAX_INFORMATION14, CA_TAX_INFORMATION15 CA_TAX_INFORMATION15, CA_TAX_INFORMATION16 CA_TAX_INFORMATION16, CA_TAX_INFORMATION17 CA_TAX_INFORMATION17, CA_TAX_INFORMATION18 CA_TAX_INFORMATION18, CA_TAX_INFORMATION19 CA_TAX_INFORMATION19, CA_TAX_INFORMATION20 CA_TAX_INFORMATION20, CA_TAX_INFORMATION21 CA_TAX_INFORMATION21, CA_TAX_INFORMATION22 CA_TAX_INFORMATION22, CA_TAX_INFORMATION23 CA_TAX_INFORMATION23, CA_TAX_INFORMATION24 CA_TAX_INFORMATION24, CA_TAX_INFORMATION25 CA_TAX_INFORMATION25, CA_TAX_INFORMATION26 CA_TAX_INFORMATION26, CA_TAX_INFORMATION27 CA_TAX_INFORMATION27, CA_TAX_INFORMATION28 CA_TAX_INFORMATION28, CA_TAX_INFORMATION29 CA_TAX_INFORMATION29, CA_TAX_INFORMATION30 CA_TAX_INFORMATION30, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PROV_LSP_AMOUNT PROV_LSP_AMOUNT, PPIP_EXEMPT_FLAG PPIP_EXEMPT_FLAG from "HR"."PAY_CA_EMP_PROV_TAX_INFO_F"

View Text - HTML Formatted

SELECT EMP_PROVINCE_TAX_INF_ID EMP_PROVINCE_TAX_INF_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, LEGISLATION_CODE LEGISLATION_CODE
, ASSIGNMENT_ID ASSIGNMENT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PROVINCE_CODE PROVINCE_CODE
, JURISDICTION_CODE JURISDICTION_CODE
, TAX_CREDIT_AMOUNT TAX_CREDIT_AMOUNT
, BASIC_EXEMPTION_FLAG BASIC_EXEMPTION_FLAG
, DEDUCTION_CODE DEDUCTION_CODE
, MARRIAGE_STATUS MARRIAGE_STATUS
, NO_OF_INFIRM_DEPENDANTS NO_OF_INFIRM_DEPENDANTS
, NON_RESIDENT_STATUS NON_RESIDENT_STATUS
, DISABILITY_STATUS DISABILITY_STATUS
, NO_OF_DEPENDANTS NO_OF_DEPENDANTS
, ANNUAL_DEDN ANNUAL_DEDN
, TOTAL_EXPENSE_BY_COMMISSION TOTAL_EXPENSE_BY_COMMISSION
, TOTAL_REMNRTN_BY_COMMISSION TOTAL_REMNRTN_BY_COMMISSION
, PRESCRIBED_ZONE_DEDN_AMT PRESCRIBED_ZONE_DEDN_AMT
, ADDITIONAL_TAX ADDITIONAL_TAX
, PROV_OVERRIDE_RATE PROV_OVERRIDE_RATE
, PROV_OVERRIDE_AMOUNT PROV_OVERRIDE_AMOUNT
, PROV_EXEMPT_FLAG PROV_EXEMPT_FLAG
, PMED_EXEMPT_FLAG PMED_EXEMPT_FLAG
, WC_EXEMPT_FLAG WC_EXEMPT_FLAG
, QPP_EXEMPT_FLAG QPP_EXEMPT_FLAG
, OTHER_TAX_CREDIT OTHER_TAX_CREDIT
, TAX_CALC_METHOD TAX_CALC_METHOD
, EXTRA_INFO_NOT_PROVIDED EXTRA_INFO_NOT_PROVIDED
, CA_TAX_INFORMATION_CATEGORY CA_TAX_INFORMATION_CATEGORY
, CA_TAX_INFORMATION1 CA_TAX_INFORMATION1
, CA_TAX_INFORMATION2 CA_TAX_INFORMATION2
, CA_TAX_INFORMATION3 CA_TAX_INFORMATION3
, CA_TAX_INFORMATION4 CA_TAX_INFORMATION4
, CA_TAX_INFORMATION5 CA_TAX_INFORMATION5
, CA_TAX_INFORMATION6 CA_TAX_INFORMATION6
, CA_TAX_INFORMATION7 CA_TAX_INFORMATION7
, CA_TAX_INFORMATION8 CA_TAX_INFORMATION8
, CA_TAX_INFORMATION9 CA_TAX_INFORMATION9
, CA_TAX_INFORMATION10 CA_TAX_INFORMATION10
, CA_TAX_INFORMATION11 CA_TAX_INFORMATION11
, CA_TAX_INFORMATION12 CA_TAX_INFORMATION12
, CA_TAX_INFORMATION13 CA_TAX_INFORMATION13
, CA_TAX_INFORMATION14 CA_TAX_INFORMATION14
, CA_TAX_INFORMATION15 CA_TAX_INFORMATION15
, CA_TAX_INFORMATION16 CA_TAX_INFORMATION16
, CA_TAX_INFORMATION17 CA_TAX_INFORMATION17
, CA_TAX_INFORMATION18 CA_TAX_INFORMATION18
, CA_TAX_INFORMATION19 CA_TAX_INFORMATION19
, CA_TAX_INFORMATION20 CA_TAX_INFORMATION20
, CA_TAX_INFORMATION21 CA_TAX_INFORMATION21
, CA_TAX_INFORMATION22 CA_TAX_INFORMATION22
, CA_TAX_INFORMATION23 CA_TAX_INFORMATION23
, CA_TAX_INFORMATION24 CA_TAX_INFORMATION24
, CA_TAX_INFORMATION25 CA_TAX_INFORMATION25
, CA_TAX_INFORMATION26 CA_TAX_INFORMATION26
, CA_TAX_INFORMATION27 CA_TAX_INFORMATION27
, CA_TAX_INFORMATION28 CA_TAX_INFORMATION28
, CA_TAX_INFORMATION29 CA_TAX_INFORMATION29
, CA_TAX_INFORMATION30 CA_TAX_INFORMATION30
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PROV_LSP_AMOUNT PROV_LSP_AMOUNT
, PPIP_EXEMPT_FLAG PPIP_EXEMPT_FLAG
FROM "HR"."PAY_CA_EMP_PROV_TAX_INFO_F"