VIEW: APPS.PAY_ELEMENT_ENTRY_VALUES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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