VIEW: APPS.PAY_CA_EMP_FED_TAX_INFO_V

Source

View Text - Preformatted

SELECT FTI.ROWID ROW_ID , FTI.EMP_FED_TAX_INF_ID EMP_FED_TAX_INF_ID , FTI. EFFECTIVE_START_DATE EFFECTIVE_START_DATE , FTI. EFFECTIVE_END_DATE EFFECTIVE_END_DATE , FTI.EFFECTIVE_END_DATE D_EFFECTIVE_END_DATE , FTI. LEGISLATION_CODE LEGISLATION_CODE , FTI. ASSIGNMENT_ID ASSIGNMENT_ID , FTI. BUSINESS_GROUP_ID BUSINESS_GROUP_ID , FTI. EMPLOYMENT_PROVINCE EMPLOYMENT_PROVINCE, HRL1.MEANING EMPLOYMENT_PROVINCE_NAME, FTI. TAX_CREDIT_AMOUNT TAX_CREDIT_AMOUNT, FTI. CLAIM_CODE CLAIM_CODE, FTI. BASIC_EXEMPTION_FLAG BASIC_EXEMPTION_FLAG, FTI. ADDITIONAL_TAX ADDITIONAL_TAX, FTI. ANNUAL_DEDN ANNUAL_DEDN, FTI. TOTAL_EXPENSE_BY_COMMISSION TOTAL_EXPENSE_BY_COMMISSION, FTI. TOTAL_REMNRTN_BY_COMMISSION TOTAL_REMNRTN_BY_COMMISSION, FTI. PRESCRIBED_ZONE_DEDN_AMT PRESCRIBED_ZONE_DEDN_AMT, FTI. OTHER_FEDTAX_CREDITS OTHER_FEDTAX_CREDITS , FTI. CPP_QPP_EXEMPT_FLAG CPP_QPP_EXEMPT_FLAG , FTI. FED_EXEMPT_FLAG FED_EXEMPT_FLAG , FTI. EI_EXEMPT_FLAG EI_EXEMPT_FLAG , FTI. TAX_CALC_METHOD TAX_CALC_METHOD , HRL.MEANING CALCULATION_METHOD , FTI. FED_OVERRIDE_AMOUNT FED_OVERRIDE_AMOUNT , FTI. FED_OVERRIDE_RATE FED_OVERRIDE_RATE , FTI. CA_TAX_INFORMATION_CATEGORY CA_TAX_INFORMATION_CATEGORY , FTI. CA_TAX_INFORMATION1 CA_TAX_INFORMATION1 , FTI. CA_TAX_INFORMATION2 CA_TAX_INFORMATION2 , FTI. CA_TAX_INFORMATION3 CA_TAX_INFORMATION3 , FTI. CA_TAX_INFORMATION4 CA_TAX_INFORMATION4 , FTI. CA_TAX_INFORMATION5 CA_TAX_INFORMATION5 , FTI. CA_TAX_INFORMATION6 CA_TAX_INFORMATION6 , FTI. CA_TAX_INFORMATION7 CA_TAX_INFORMATION7 , FTI. CA_TAX_INFORMATION8 CA_TAX_INFORMATION8 , FTI. CA_TAX_INFORMATION9 CA_TAX_INFORMATION9 , FTI. CA_TAX_INFORMATION10 CA_TAX_INFORMATION10 , FTI. CA_TAX_INFORMATION11 CA_TAX_INFORMATION11 , FTI. CA_TAX_INFORMATION12 CA_TAX_INFORMATION12 , FTI. CA_TAX_INFORMATION13 CA_TAX_INFORMATION13 , FTI. CA_TAX_INFORMATION14 CA_TAX_INFORMATION14 , FTI. CA_TAX_INFORMATION15 CA_TAX_INFORMATION15 , FTI. CA_TAX_INFORMATION16 CA_TAX_INFORMATION16 , FTI. CA_TAX_INFORMATION17 CA_TAX_INFORMATION17 , FTI. CA_TAX_INFORMATION18 CA_TAX_INFORMATION18 , FTI. CA_TAX_INFORMATION19 CA_TAX_INFORMATION19 , FTI. CA_TAX_INFORMATION20 CA_TAX_INFORMATION20 , FTI. CA_TAX_INFORMATION21 CA_TAX_INFORMATION21 , FTI. CA_TAX_INFORMATION22 CA_TAX_INFORMATION22 , FTI. CA_TAX_INFORMATION23 CA_TAX_INFORMATION23 , FTI. CA_TAX_INFORMATION24 CA_TAX_INFORMATION24 , FTI. CA_TAX_INFORMATION25 CA_TAX_INFORMATION25 , FTI. CA_TAX_INFORMATION26 CA_TAX_INFORMATION26 , FTI. CA_TAX_INFORMATION27 CA_TAX_INFORMATION27 , FTI. CA_TAX_INFORMATION28 CA_TAX_INFORMATION28 , FTI. CA_TAX_INFORMATION29 CA_TAX_INFORMATION29 , FTI. CA_TAX_INFORMATION30 CA_TAX_INFORMATION30 , FTI. OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER , FTI.FED_LSF_AMOUNT FED_LSF_AMOUNT , FTI.CPP_ELECTION_DATE CPP_ELECTION_DATE , FTI.CPP_REVOCATION_DATE CPP_REVOCATION_DATE, FTI. CREATED_BY CREATED_BY , FTI. CREATION_DATE CREATION_DATE , FTI. LAST_UPDATED_BY LAST_UPDATED_BY , FTI. LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , FTI. LAST_UPDATE_DATE LAST_UPDATE_DATE FROM HR_LOOKUPS HRL, FND_SESSIONS FND, HR_LOOKUPS HRL1, PAY_CA_EMP_FED_TAX_INFO_F FTI WHERE FND.SESSION_ID = USERENV('sessionid') AND FND.EFFECTIVE_DATE BETWEEN FTI.EFFECTIVE_START_DATE AND FTI.EFFECTIVE_END_DATE AND FTI.tax_calc_method = HRL.LOOKUP_CODE(+) AND HRL.LOOKUP_TYPE(+) = 'CA_TAX_CALC_METHOD' AND FTI.EMPLOYMENT_PROVINCE = HRL1.LOOKUP_CODE(+) AND HRL1.LOOKUP_TYPE(+) = 'CA_PROVINCE'

View Text - HTML Formatted

SELECT FTI.ROWID ROW_ID
, FTI.EMP_FED_TAX_INF_ID EMP_FED_TAX_INF_ID
, FTI. EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, FTI. EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, FTI.EFFECTIVE_END_DATE D_EFFECTIVE_END_DATE
, FTI. LEGISLATION_CODE LEGISLATION_CODE
, FTI. ASSIGNMENT_ID ASSIGNMENT_ID
, FTI. BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, FTI. EMPLOYMENT_PROVINCE EMPLOYMENT_PROVINCE
, HRL1.MEANING EMPLOYMENT_PROVINCE_NAME
, FTI. TAX_CREDIT_AMOUNT TAX_CREDIT_AMOUNT
, FTI. CLAIM_CODE CLAIM_CODE
, FTI. BASIC_EXEMPTION_FLAG BASIC_EXEMPTION_FLAG
, FTI. ADDITIONAL_TAX ADDITIONAL_TAX
, FTI. ANNUAL_DEDN ANNUAL_DEDN
, FTI. TOTAL_EXPENSE_BY_COMMISSION TOTAL_EXPENSE_BY_COMMISSION
, FTI. TOTAL_REMNRTN_BY_COMMISSION TOTAL_REMNRTN_BY_COMMISSION
, FTI. PRESCRIBED_ZONE_DEDN_AMT PRESCRIBED_ZONE_DEDN_AMT
, FTI. OTHER_FEDTAX_CREDITS OTHER_FEDTAX_CREDITS
, FTI. CPP_QPP_EXEMPT_FLAG CPP_QPP_EXEMPT_FLAG
, FTI. FED_EXEMPT_FLAG FED_EXEMPT_FLAG
, FTI. EI_EXEMPT_FLAG EI_EXEMPT_FLAG
, FTI. TAX_CALC_METHOD TAX_CALC_METHOD
, HRL.MEANING CALCULATION_METHOD
, FTI. FED_OVERRIDE_AMOUNT FED_OVERRIDE_AMOUNT
, FTI. FED_OVERRIDE_RATE FED_OVERRIDE_RATE
, FTI. CA_TAX_INFORMATION_CATEGORY CA_TAX_INFORMATION_CATEGORY
, FTI. CA_TAX_INFORMATION1 CA_TAX_INFORMATION1
, FTI. CA_TAX_INFORMATION2 CA_TAX_INFORMATION2
, FTI. CA_TAX_INFORMATION3 CA_TAX_INFORMATION3
, FTI. CA_TAX_INFORMATION4 CA_TAX_INFORMATION4
, FTI. CA_TAX_INFORMATION5 CA_TAX_INFORMATION5
, FTI. CA_TAX_INFORMATION6 CA_TAX_INFORMATION6
, FTI. CA_TAX_INFORMATION7 CA_TAX_INFORMATION7
, FTI. CA_TAX_INFORMATION8 CA_TAX_INFORMATION8
, FTI. CA_TAX_INFORMATION9 CA_TAX_INFORMATION9
, FTI. CA_TAX_INFORMATION10 CA_TAX_INFORMATION10
, FTI. CA_TAX_INFORMATION11 CA_TAX_INFORMATION11
, FTI. CA_TAX_INFORMATION12 CA_TAX_INFORMATION12
, FTI. CA_TAX_INFORMATION13 CA_TAX_INFORMATION13
, FTI. CA_TAX_INFORMATION14 CA_TAX_INFORMATION14
, FTI. CA_TAX_INFORMATION15 CA_TAX_INFORMATION15
, FTI. CA_TAX_INFORMATION16 CA_TAX_INFORMATION16
, FTI. CA_TAX_INFORMATION17 CA_TAX_INFORMATION17
, FTI. CA_TAX_INFORMATION18 CA_TAX_INFORMATION18
, FTI. CA_TAX_INFORMATION19 CA_TAX_INFORMATION19
, FTI. CA_TAX_INFORMATION20 CA_TAX_INFORMATION20
, FTI. CA_TAX_INFORMATION21 CA_TAX_INFORMATION21
, FTI. CA_TAX_INFORMATION22 CA_TAX_INFORMATION22
, FTI. CA_TAX_INFORMATION23 CA_TAX_INFORMATION23
, FTI. CA_TAX_INFORMATION24 CA_TAX_INFORMATION24
, FTI. CA_TAX_INFORMATION25 CA_TAX_INFORMATION25
, FTI. CA_TAX_INFORMATION26 CA_TAX_INFORMATION26
, FTI. CA_TAX_INFORMATION27 CA_TAX_INFORMATION27
, FTI. CA_TAX_INFORMATION28 CA_TAX_INFORMATION28
, FTI. CA_TAX_INFORMATION29 CA_TAX_INFORMATION29
, FTI. CA_TAX_INFORMATION30 CA_TAX_INFORMATION30
, FTI. OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FTI.FED_LSF_AMOUNT FED_LSF_AMOUNT
, FTI.CPP_ELECTION_DATE CPP_ELECTION_DATE
, FTI.CPP_REVOCATION_DATE CPP_REVOCATION_DATE
, FTI. CREATED_BY CREATED_BY
, FTI. CREATION_DATE CREATION_DATE
, FTI. LAST_UPDATED_BY LAST_UPDATED_BY
, FTI. LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FTI. LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM HR_LOOKUPS HRL
, FND_SESSIONS FND
, HR_LOOKUPS HRL1
, PAY_CA_EMP_FED_TAX_INFO_F FTI
WHERE FND.SESSION_ID = USERENV('SESSIONID')
AND FND.EFFECTIVE_DATE BETWEEN FTI.EFFECTIVE_START_DATE
AND FTI.EFFECTIVE_END_DATE
AND FTI.TAX_CALC_METHOD = HRL.LOOKUP_CODE(+)
AND HRL.LOOKUP_TYPE(+) = 'CA_TAX_CALC_METHOD'
AND FTI.EMPLOYMENT_PROVINCE = HRL1.LOOKUP_CODE(+)
AND HRL1.LOOKUP_TYPE(+) = 'CA_PROVINCE'