VIEW: APPS.PAY_CA_EMP_PROV_TAX_INFO_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'