View: PAY_PAYWIEEH_ELEMENT_ENTRIES

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

View Text

SELECT NVL( ENTRY.ORIGINAL_ENTRY_ID
, ENTRY.ELEMENT_ENTRY_ID )
, ENTRY.ASSIGNMENT_ID
, ENTRY.EFFECTIVE_START_DATE
, ENTRY.EFFECTIVE_END_DATE
, ENTRY.COST_ALLOCATION_KEYFLEX_ID
, ENTRY.ELEMENT_LINK_ID
, ENTRY.ENTRY_TYPE
, HR_GENERAL.DECODE_LOOKUP ('ENTRY_TYPE'
, ENTRY.ENTRY_TYPE)
, ENTRY.COMMENT_ID
, HR_GENERAL.DECODE_LOOKUP ('ELE_ENTRY_REASON'
, ENTRY.REASON)
, ENTRY.ATTRIBUTE_CATEGORY
, ENTRY.ATTRIBUTE1
, ENTRY.ATTRIBUTE2
, ENTRY.ATTRIBUTE3
, ENTRY.ATTRIBUTE4
, ENTRY.ATTRIBUTE5
, ENTRY.ATTRIBUTE6
, ENTRY.ATTRIBUTE7
, ENTRY.ATTRIBUTE8
, ENTRY.ATTRIBUTE9
, ENTRY.ATTRIBUTE10
, ENTRY.ATTRIBUTE11
, ENTRY.ATTRIBUTE12
, ENTRY.ATTRIBUTE13
, ENTRY.ATTRIBUTE14
, ENTRY.ATTRIBUTE15
, ENTRY.ATTRIBUTE16
, ENTRY.ATTRIBUTE17
, ENTRY.ATTRIBUTE18
, ENTRY.ATTRIBUTE19
, ENTRY.ATTRIBUTE20
, ELEMENT.ELEMENT_TYPE_ID
, ELEMENTTL.ELEMENT_NAME
, ELEMENT.PROCESSING_TYPE
, ELEMENT.INPUT_CURRENCY_CODE
, ELEMENT.CLASSIFICATION_ID
, BENEFIT.CONTRIBUTIONS_USED
, ELEMENT.ROWID
, ENTRY.CREATION_DATE
, ENTRY.CREATED_BY
, ENTRY.LAST_UPDATE_LOGIN
, ENTRY.LAST_UPDATED_BY
, ENTRY.LAST_UPDATE_DATE
FROM PAY_ELEMENT_TYPES_F_TL ELEMENTTL
, PAY_ELEMENT_TYPES_F ELEMENT
, PAY_ELEMENT_ENTRIES_F ENTRY
, PAY_ELEMENT_LINKS_F LINK
, BEN_BENEFIT_CLASSIFICATIONS BENEFIT
WHERE ELEMENT.ELEMENT_TYPE_ID = ELEMENTTL.ELEMENT_TYPE_ID
AND ELEMENTTL.LANGUAGE = USERENV('LANG')
AND ELEMENT.ELEMENT_TYPE_ID = LINK.ELEMENT_TYPE_ID
AND ELEMENT.BENEFIT_CLASSIFICATION_ID = BENEFIT.BENEFIT_CLASSIFICATION_ID(+)
AND ENTRY.ELEMENT_LINK_ID = LINK.ELEMENT_LINK_ID
AND ENTRY.EFFECTIVE_END_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE
AND ELEMENT.EFFECTIVE_END_DATE
AND ENTRY.EFFECTIVE_END_DATE BETWEEN LINK.EFFECTIVE_START_DATE
AND LINK.EFFECTIVE_END_DATE
AND ENTRY.CREATOR_TYPE IN ( 'F'
, /* MISCELLANEOUS ENTRIES */ 'A'
, /* ABSENCE */ 'S'
, /* STATUTORY SICK PAY ENTRIES */ 'M'
, /* STATUTORY MATERNITY PAY ENTRIES */ 'H'
, /* MIX ENTRIES */ 'SP'
, /* SALARY PROPOSAL */ 'P'
, /* BACKPAY */ 'D'
, /* ADVANCE PAY */ 'DF'
, /* ADVANCE PAY FORM */ 'R' /* RETROPAY BY ACTION */ )
AND ENTRY.ENTRY_TYPE IN ( 'E'
, /* NORMAL ENTRY */ 'D'
, /* ADDITIONAL ENTRY */ 'S' /* OVERRIDE */ )

Columns