View: PAY_PAYAUTAX_PYE_ENT_V

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

View Text

SELECT PEE.ROWID
, PEE.OBJECT_VERSION_NUMBER
, PEE.ELEMENT_ENTRY_ID
, EEV0.INPUT_VALUE_ID
, HRL0.MEANING
, EEV0.SCREEN_ENTRY_VALUE
, EEV1.INPUT_VALUE_ID
, HRL1.MEANING
, EEV1.SCREEN_ENTRY_VALUE
, EEV2.INPUT_VALUE_ID
, EEV2.SCREEN_ENTRY_VALUE
, EEV2.SCREEN_ENTRY_VALUE
, EEV3.INPUT_VALUE_ID
, HRL3.MEANING
, EEV3.SCREEN_ENTRY_VALUE
, 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
, EEV7.INPUT_VALUE_ID
, HRL7.MEANING
, EEV7.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
, HRL8.MEANING
, DECODE(EEV8.SCREEN_ENTRY_VALUE
, 'YY'
, 'Y'
, 'NY'
, 'Y'
, 'N') MLS_ENTRY_VALUE
, EEV9.INPUT_VALUE_ID
, EEV9.SCREEN_ENTRY_VALUE
, EEV9.SCREEN_ENTRY_VALUE
, EEV10.INPUT_VALUE_ID
, EEV10.SCREEN_ENTRY_VALUE
, EEV10.SCREEN_ENTRY_VALUE
, EEV11.INPUT_VALUE_ID
, EEV11.SCREEN_ENTRY_VALUE
, EEV11.SCREEN_ENTRY_VALUE
, EEV13.INPUT_VALUE_ID
, EEV13.SCREEN_ENTRY_VALUE
, EEV13.SCREEN_ENTRY_VALUE
, PEE.ASSIGNMENT_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
FROM PAY_ELEMENT_ENTRY_VALUES_F EEV1
, PAY_INPUT_VALUES_F PIV1
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_ENTRIES_F PEE
, PAY_ELEMENT_ENTRY_VALUES_F EEV0
, PAY_INPUT_VALUES_F PIV0
, PAY_ELEMENT_ENTRY_VALUES_F EEV2
, PAY_INPUT_VALUES_F PIV2
, PAY_ELEMENT_ENTRY_VALUES_F EEV3
, PAY_INPUT_VALUES_F PIV3
, PAY_ELEMENT_ENTRY_VALUES_F EEV4
, PAY_INPUT_VALUES_F PIV4
, PAY_ELEMENT_ENTRY_VALUES_F EEV5
, PAY_INPUT_VALUES_F PIV5
, PAY_ELEMENT_ENTRY_VALUES_F EEV6
, PAY_INPUT_VALUES_F PIV6
, PAY_ELEMENT_ENTRY_VALUES_F EEV7
, PAY_INPUT_VALUES_F PIV7
, PAY_ELEMENT_ENTRY_VALUES_F EEV8
, PAY_INPUT_VALUES_F PIV8
, PAY_ELEMENT_ENTRY_VALUES_F EEV9
, PAY_INPUT_VALUES_F PIV9
, PAY_ELEMENT_ENTRY_VALUES_F EEV10
, PAY_INPUT_VALUES_F PIV10
, PAY_ELEMENT_ENTRY_VALUES_F EEV11
, PAY_INPUT_VALUES_F PIV11
, PAY_ELEMENT_ENTRY_VALUES_F EEV13
, PAY_INPUT_VALUES_F PIV13
, HR_LOOKUPS HRL0
, HR_LOOKUPS HRL1
, HR_LOOKUPS HRL3
, HR_LOOKUPS HRL4
, HR_LOOKUPS HRL5
, HR_LOOKUPS HRL7
, HR_LOOKUPS HRL8
, FND_SESSIONS SES
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 (PIV0.NAME) = 'AUSTRALIAN RESIDENT'
AND HRL0.LOOKUP_TYPE (+) = 'YES_NO'
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 EEV2.INPUT_VALUE_ID = PIV2.INPUT_VALUE_ID
AND PIV2.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV2.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV2.NAME) = 'REBATE AMOUNT'
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 (+) = 'YES_NO'
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 EEV7.INPUT_VALUE_ID = PIV7.INPUT_VALUE_ID
AND PIV7.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV7.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV7.NAME) = 'MEDICARE LEVY VARIATION'
AND HRL7.LOOKUP_TYPE (+) = 'AU_MED_LEV_VAR'
AND HRL7.LOOKUP_CODE (+) = EEV7.SCREEN_ENTRY_VALUE
AND HRL7.ENABLED_FLAG (+) = 'Y'
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 EEV9.INPUT_VALUE_ID = PIV9.INPUT_VALUE_ID
AND PIV9.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV9.ELEMENT_ENTRY_ID = PEE.ELEMENT_ENTRY_ID
AND (PIV9.NAME ) = 'DEPENDENT CHILDREN'
AND EEV10.INPUT_VALUE_ID = PIV10.INPUT_VALUE_ID
AND PIV10.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV10.ELEMENT_ENTRY_ID= PEE.ELEMENT_ENTRY_ID
AND (PIV10.NAME) = 'TAX VARIATION TYPE'
AND EEV11.INPUT_VALUE_ID = PIV11.INPUT_VALUE_ID
AND PIV11.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND EEV11.ELEMENT_ENTRY_ID= PEE.ELEMENT_ENTRY_ID
AND (PIV11.NAME ) = 'TAX VARIATION AMOUNT'
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 SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PEE.EFFECTIVE_START_DATE
AND PEE.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV0.EFFECTIVE_START_DATE
AND EEV0.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV1.EFFECTIVE_START_DATE
AND EEV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV2.EFFECTIVE_START_DATE
AND EEV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV3.EFFECTIVE_START_DATE
AND EEV3.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV4.EFFECTIVE_START_DATE
AND EEV4.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV5.EFFECTIVE_START_DATE
AND EEV5.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV6.EFFECTIVE_START_DATE
AND EEV6.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV7.EFFECTIVE_START_DATE
AND EEV7.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV8.EFFECTIVE_START_DATE
AND EEV8.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV9.EFFECTIVE_START_DATE
AND EEV9.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV10.EFFECTIVE_START_DATE
AND EEV10.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV11.EFFECTIVE_START_DATE
AND EEV11.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV13.EFFECTIVE_START_DATE
AND EEV13.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV0.EFFECTIVE_START_DATE
AND PIV0.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV1.EFFECTIVE_START_DATE
AND PIV1.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV2.EFFECTIVE_START_DATE
AND PIV2.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV3.EFFECTIVE_START_DATE
AND PIV3.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV4.EFFECTIVE_START_DATE
AND PIV4.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV5.EFFECTIVE_START_DATE
AND PIV5.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV6.EFFECTIVE_START_DATE
AND PIV6.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV7.EFFECTIVE_START_DATE
AND PIV7.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV8.EFFECTIVE_START_DATE
AND PIV8.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV9.EFFECTIVE_START_DATE
AND PIV9.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV10.EFFECTIVE_START_DATE
AND PIV10.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV11.EFFECTIVE_START_DATE
AND PIV11.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV13.EFFECTIVE_START_DATE
AND PIV13.EFFECTIVE_END_DATE

Columns