VIEW: APPS.PAY_LEE_VALUES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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