View: PAY_PAYAUTAX_SPR_ENT_V

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

View Text

SELECT PEE.ROWID
, PEE.ELEMENT_ENTRY_ID
, EEV0.INPUT_VALUE_ID
, HRL0.MEANING
, EEV0.SCREEN_ENTRY_VALUE
, PEE.ASSIGNMENT_ID
, PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
FROM PAY_ELEMENT_ENTRY_VALUES_F EEV0
, PAY_INPUT_VALUES_F PIV0
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_ENTRIES_F PEE
, HR_LOOKUPS HRL0
, FND_SESSIONS SES
WHERE PET.ELEMENT_NAME = 'SUPERANNUATION GUARANTEE 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 = 'TFN FOR SUPERANNUATION'
AND HRL0.LOOKUP_TYPE (+) = 'YES_NO'
AND HRL0.LOOKUP_CODE (+) = EEV0.SCREEN_ENTRY_VALUE
AND HRL0.ENABLED_FLAG (+)= 'Y'
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN EEV0.EFFECTIVE_START_DATE
AND EEV0.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PIV0.EFFECTIVE_START_DATE
AND PIV0.EFFECTIVE_END_DATE
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

Columns