View: PAY_LEE_VALUES_V

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

View Text

SELECT /*+ ORDERED INDEX(PEE PAY_ELEMENT_ENTRIES_F_N4) USE_NL(PEE PAF PPF FS) */ PEE.EFFECTIVE_START_DATE
, PEE.EFFECTIVE_END_DATE
, PEE.ELEMENT_ENTRY_ID
, PEE.ELEMENT_LINK_ID
, PEE.ENTRY_TYPE
, PEE.ASSIGNMENT_ID
, PEL.ELEMENT_TYPE_ID
, PEE.LAST_UPDATE_DATE
, PEE.LAST_UPDATED_BY
, PEE.LAST_UPDATE_LOGIN
, PEE.CREATED_BY
, PEE.CREATION_DATE
, PEE.ROWID
, PPF.FULL_NAME
, PAF.ASSIGNMENT_NUMBER
, HR_GENERAL.DECODE_LOOKUP('ENTRY_TYPE'
, PEE.ENTRY_TYPE) ENTRY_TYPE_NAME
, PEL.BUSINESS_GROUP_ID
, PPF.CURRENT_EMPLOYEE_FLAG
FROM PAY_ELEMENT_LINKS_F PEL
, FND_SESSIONS FS
, PAY_ELEMENT_ENTRIES_F PEE
, PER_ASSIGNMENTS_F PAF
, PER_PEOPLE_F PPF
WHERE PEE.ELEMENT_LINK_ID = PEL.ELEMENT_LINK_ID+0
AND PEE.EFFECTIVE_START_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE
AND PEE.ENTRY_TYPE IN ('S'
, 'D'
, 'E') /* ASSIGNMENT AS OF THE ENTRY START DATE */
AND PAF.ASSIGNMENT_ID = PEE.ASSIGNMENT_ID
AND PEE.EFFECTIVE_START_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PAF.ASSIGNMENT_TYPE = 'E' /* PERSON AS OF THE EFFECTIVE DATE */
AND FS.SESSION_ID = USERENV('SESSIONID')
AND PPF.PERSON_ID = PAF.PERSON_ID
AND FS.EFFECTIVE_DATE BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE

Columns