View: PAY_ELEMENT_ENTRY_VALUES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_ELEMENT_ENTRY_VALUES_V

View Text

SELECT PEO.FULL_NAME
, ASG.ASSIGNMENT_NUMBER
, ASG.ASSIGNMENT_ID
, EEV.SCREEN_ENTRY_VALUE
, EE.EFFECTIVE_START_DATE
, EE.LAST_UPDATE_DATE
, EE.LAST_UPDATED_BY
, EE.LAST_UPDATE_LOGIN
, EE.CREATED_BY
, EE.CREATION_DATE
, DECODE(EE.EFFECTIVE_END_DATE
, TO_DATE('31/12/4712'
, 'DD/MM/YYYY')
, NULL
, EE.EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
, EEV.INPUT_VALUE_ID
, ASG.GRADE_ID
FROM FND_SESSIONS SES
, PER_PEOPLE_F PEO
, PAY_ELEMENT_ENTRY_VALUES_F EEV
, PAY_ELEMENT_ENTRIES_F EE
, PER_ALL_ASSIGNMENTS_F ASG
WHERE SES.SESSION_ID = USERENV('SESSIONID')
AND ASG.ASSIGNMENT_ID = EE.ASSIGNMENT_ID
AND EEV.ELEMENT_ENTRY_ID = EE.ELEMENT_ENTRY_ID
AND EEV.EFFECTIVE_START_DATE = EE.EFFECTIVE_START_DATE
AND EEV.EFFECTIVE_END_DATE = EE.EFFECTIVE_END_DATE
AND PEO.PERSON_ID = ASG.PERSON_ID
AND SES.EFFECTIVE_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EEV.EFFECTIVE_START_DATE
AND EEV.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN EE.EFFECTIVE_START_DATE
AND EE.EFFECTIVE_END_DATE

Columns