Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_CA_EMP_FED_TAX_INFO_V |
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. 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'