View: PAY_AU_TFN_TAX_INFO_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_AU_TFN_TAX_INFO_V

View Text

SELECT PEE.ROWID
, PEE.OBJECT_VERSION_NUMBER
, PEE.ELEMENT_ENTRY_ID
, EEV0.INPUT_VALUE_ID
, HRL0.MEANING
, DECODE(EEV0.SCREEN_ENTRY_VALUE
, 'YS'
, 'Y'
, 'YI'
, 'Y'
, 'YC'
, 'Y'
, 'NN'
, 'N'
, 'YN'
, 'Y'
, 'Y'
, 'Y'
, 'N'
, 'N'
, NULL)
, EEV1.INPUT_VALUE_ID
, HRL1.MEANING
, EEV1.SCREEN_ENTRY_VALUE
, EEV3.INPUT_VALUE_ID
, HRL3.MEANING
, DECODE( EEV3.SCREEN_ENTRY_VALUE
, 'N'
, 'N'
, 'Y'
, 'Y'
, 'NF'
, 'N'
, 'NP'
, 'N'
, 'NC'
, 'N'
, 'YF'
, 'Y'
, 'YP'
, 'Y'
, 'YC'
, 'Y'
, 'N' )
, DECODE( EEV3.SCREEN_ENTRY_VALUE
, 'Y'
, 'X'
, 'N'
, 'X'
, 'NF'
, 'F'
, 'NP'
, 'P'
, 'NC'
, 'C'
, 'YF'
, 'F'
, 'YP'
, 'P'
, 'YC'
, 'C'
, 'X')
, EEV4.INPUT_VALUE_ID
, HRL4.MEANING
, EEV4.SCREEN_ENTRY_VALUE
, EEV5.INPUT_VALUE_ID
, HRL5.MEANING
, DECODE(EEV5.SCREEN_ENTRY_VALUE
, 'Y'
, 'Y'
, 'N'
, 'N'
, 'YY'
, 'Y'
, 'NY'
, 'N'
, NULL) HECS_ENTRY_VALUE
, HRL5.MEANING
, DECODE(EEV5.SCREEN_ENTRY_VALUE
, 'YY'
, 'Y'
, 'NY'
, 'Y'
, 'N') SFSS_ENTRY_VALUE
, EEV6.INPUT_VALUE_ID
, EEV6.SCREEN_ENTRY_VALUE
, EEV6.SCREEN_ENTRY_VALUE
, EEV8.INPUT_VALUE_ID
, HRL8.MEANING
, DECODE(EEV8.SCREEN_ENTRY_VALUE
, 'Y'
, 'Y'
, 'N'
, 'N'
, 'YY'
, 'Y'
, 'NY'
, 'N'
, NULL) SPOUSE_ENTRY_VALUE
, DECODE(DECODE(EEV8.SCREEN_ENTRY_VALUE
, 'Y'
, 'Y'
, 'N'
, 'N'
, 'YY'
, 'Y'
, 'NY'
, 'N'
, 'N')
, 'Y'
, 'Y'
, DECODE(EEV4.SCREEN_ENTRY_VALUE
, 'Y'
, 'Y'
, 'N'))
, EEV13.INPUT_VALUE_ID
, EEV13.SCREEN_ENTRY_VALUE
, EEV13.SCREEN_ENTRY_VALUE
, PEE.ASSIGNMENT_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, TRUNC(FND_DATE.CANONICAL_TO_DATE(PEE.ENTRY_INFORMATION1))
FROM PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_TYPES_F PET
, PAY_INPUT_VALUES_F PIV0
, PAY_ELEMENT_ENTRY_VALUES_F EEV0
, PAY_INPUT_VALUES_F PIV1
, PAY_ELEMENT_ENTRY_VALUES_F EEV1
, PAY_INPUT_VALUES_F PIV3
, PAY_ELEMENT_ENTRY_VALUES_F EEV3
, PAY_INPUT_VALUES_F PIV4
, PAY_ELEMENT_ENTRY_VALUES_F EEV4
, PAY_INPUT_VALUES_F PIV5
, PAY_ELEMENT_ENTRY_VALUES_F EEV5
, PAY_INPUT_VALUES_F PIV6
, PAY_ELEMENT_ENTRY_VALUES_F EEV6
, PAY_INPUT_VALUES_F PIV8
, PAY_ELEMENT_ENTRY_VALUES_F EEV8
, PAY_INPUT_VALUES_F PIV13
, PAY_ELEMENT_ENTRY_VALUES_F EEV13
, HR_LOOKUPS HRL0
, HR_LOOKUPS HRL1
, HR_LOOKUPS HRL3
, HR_LOOKUPS HRL4
, HR_LOOKUPS HRL5
, HR_LOOKUPS HRL8
WHERE PET.ELEMENT_NAME= 'TAX INFORMATION'
AND PET.ELEMENT_TYPE_ID = PIV0.ELEMENT_TYPE_ID
AND EEV0.INPUT_VALUE_ID = PIV0.INPUT_VALUE_ID
AND EEV0.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND PEE.ENTRY_INFORMATION_CATEGORY = 'AU_TAX DEDUCTIONS'
AND (PIV0.NAME) = 'AUSTRALIAN RESIDENT'
AND HRL0.LOOKUP_TYPE (+) = 'AU_AUST_RES_SENR_AUS'
AND HRL0.LOOKUP_CODE (+) = EEV0.SCREEN_ENTRY_VALUE
AND HRL0.ENABLED_FLAG (+)= 'Y'
AND EEV1.INPUT_VALUE_ID = PIV1.INPUT_VALUE_ID
AND EEV1.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND PIV1.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND (PIV1.NAME) = 'TAX FREE THRESHOLD'
AND HRL1.LOOKUP_TYPE (+) = 'YES_NO'
AND HRL1.LOOKUP_CODE (+) = EEV1.SCREEN_ENTRY_VALUE
AND HRL1.ENABLED_FLAG (+)= 'Y'
AND EEV3.INPUT_VALUE_ID = PIV3.INPUT_VALUE_ID
AND PIV3.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV3.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV3.NAME) = 'FTA CLAIM'
AND HRL3.LOOKUP_TYPE (+) = 'HR_AU_FTA_PAYMENT_BASIS'
AND HRL3.LOOKUP_CODE (+) = EEV3.SCREEN_ENTRY_VALUE
AND HRL3.ENABLED_FLAG (+) = 'Y'
AND EEV4.INPUT_VALUE_ID = PIV4.INPUT_VALUE_ID
AND PIV4.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV4.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV4.NAME) = 'SAVINGS REBATE'
AND HRL4.LOOKUP_TYPE(+) = 'YES_NO'
AND HRL4.LOOKUP_CODE(+) = EEV4.SCREEN_ENTRY_VALUE
AND HRL4.ENABLED_FLAG (+) = 'Y'
AND EEV5.INPUT_VALUE_ID = PIV5.INPUT_VALUE_ID
AND PIV5.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV5.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV5.NAME) = 'HECS'
AND HRL5.LOOKUP_TYPE(+) = 'AU_HECS_SFSS'
AND HRL5.LOOKUP_CODE (+) = EEV5.SCREEN_ENTRY_VALUE
AND HRL5.ENABLED_FLAG (+) = 'Y'
AND EEV6.INPUT_VALUE_ID = PIV6.INPUT_VALUE_ID
AND PIV6.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV6.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV6.NAME) = 'DATE DECLARATION SIGNED'
AND EEV8.INPUT_VALUE_ID = PIV8.INPUT_VALUE_ID
AND PIV8.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV8.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV8.NAME) = 'SPOUSE'
AND HRL8.LOOKUP_TYPE (+) = 'AU_SPOUSE_MLS'
AND HRL8.LOOKUP_CODE (+) = EEV8.SCREEN_ENTRY_VALUE
AND HRL8.ENABLED_FLAG (+) = 'Y'
AND EEV13.INPUT_VALUE_ID = PIV13.INPUT_VALUE_ID
AND PIV13.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV13.ELEMENT_ENTRY_ID= PEE.ELEMENT_ENTRY_ID
AND (PIV13.NAME ) = 'TAX FILE NUMBER'
AND PEE.EFFECTIVE_START_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND EEV0.EFFECTIVE_START_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND EEV1.EFFECTIVE_START_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND EEV3.EFFECTIVE_START_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND EEV4.EFFECTIVE_START_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND EEV5.EFFECTIVE_START_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND EEV6.EFFECTIVE_START_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND EEV8.EFFECTIVE_START_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND EEV13.EFFECTIVE_START_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND EEV0.EFFECTIVE_START_DATE BETWEEN PIV0.EFFECTIVE_START_DATE
AND PIV0.EFFECTIVE_END_DATE
AND EEV1.EFFECTIVE_START_DATE BETWEEN PIV1.EFFECTIVE_START_DATE
AND PIV1.EFFECTIVE_END_DATE
AND EEV3.EFFECTIVE_START_DATE BETWEEN PIV3.EFFECTIVE_START_DATE
AND PIV3.EFFECTIVE_END_DATE
AND EEV4.EFFECTIVE_START_DATE BETWEEN PIV4.EFFECTIVE_START_DATE
AND PIV4.EFFECTIVE_END_DATE
AND EEV5.EFFECTIVE_START_DATE BETWEEN PIV5.EFFECTIVE_START_DATE
AND PIV5.EFFECTIVE_END_DATE
AND EEV6.EFFECTIVE_START_DATE BETWEEN PIV6.EFFECTIVE_START_DATE
AND PIV6.EFFECTIVE_END_DATE
AND EEV8.EFFECTIVE_START_DATE BETWEEN PIV8.EFFECTIVE_START_DATE
AND PIV8.EFFECTIVE_END_DATE
AND EEV13.EFFECTIVE_START_DATE BETWEEN PIV13.EFFECTIVE_START_DATE
AND PIV13.EFFECTIVE_END_DATE

Columns