VIEW: APPS.PAY_PAYWIEEH_ELEMENT_ENTRIES

Source

View Text - Preformatted

SELECT NVL( ENTRY.ORIGINAL_ENTRY_ID, ENTRY.ELEMENT_ENTRY_ID ) 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_TYPE_NAME, ENTRY.COMMENT_ID , HR_GENERAL.DECODE_LOOKUP ('ELE_ENTRY_REASON', ENTRY.REASON) 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 ROW_ID, 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 ('A' /* ABSENCE */, 'AD' /* ADVANCE DEDUCTION */, 'AE' /* ADVANCE ENTRY */, 'D' /* ADVANCE PAY */, 'DF' /* ADVANCE PAY FORM */, 'EE' /* RETROPAY BY ELEMENT, SOURCE ID POINTS TO ELEMENT ENTRY */, 'F' /* ELEMENT ENTRY/OVERRIDE FORM */, 'FL' /* FLSA ENTRY OWNED/DEPENDENT ON ANOTHER (PARENT) ELEMENT ENTRY */, 'H' /* MIX */, 'M' /* STATUTORY MATERNITY PAY */, 'NR' /* RETROPAY BY ELEMENT, NEGATIVE REPLACEMENT */, 'P' /* BACKPAY */, 'PR' /* RETROPAY BY ELEMENT, POSITIVE REPLACEMENT */, 'R' /* RETROPAY BY ACTION */, 'RR' /* RETROPAY BY ELEMENT, SOURCE ID POINTS TO RUN RESULT */, 'S' /* SSP */, 'SP' /* SALARY PROPOSAL */) AND ENTRY.ENTRY_TYPE IN ( 'E', /* NORMAL ENTRY */ 'D', /* ADDITIONAL ENTRY */ 'S' /* OVERRIDE */ )

View Text - HTML Formatted

SELECT NVL( ENTRY.ORIGINAL_ENTRY_ID
, ENTRY.ELEMENT_ENTRY_ID ) 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_TYPE_NAME
, ENTRY.COMMENT_ID
, HR_GENERAL.DECODE_LOOKUP ('ELE_ENTRY_REASON'
, ENTRY.REASON) 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 ROW_ID
, 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 ('A' /* ABSENCE */
, 'AD' /* ADVANCE DEDUCTION */
, 'AE' /* ADVANCE ENTRY */
, 'D' /* ADVANCE PAY */
, 'DF' /* ADVANCE PAY FORM */
, 'EE' /* RETROPAY BY ELEMENT
, SOURCE ID POINTS TO ELEMENT ENTRY */
, 'F' /* ELEMENT ENTRY/OVERRIDE FORM */
, 'FL' /* FLSA ENTRY OWNED/DEPENDENT ON ANOTHER (PARENT) ELEMENT ENTRY */
, 'H' /* MIX */
, 'M' /* STATUTORY MATERNITY PAY */
, 'NR' /* RETROPAY BY ELEMENT
, NEGATIVE REPLACEMENT */
, 'P' /* BACKPAY */
, 'PR' /* RETROPAY BY ELEMENT
, POSITIVE REPLACEMENT */
, 'R' /* RETROPAY BY ACTION */
, 'RR' /* RETROPAY BY ELEMENT
, SOURCE ID POINTS TO RUN RESULT */
, 'S' /* SSP */
, 'SP' /* SALARY PROPOSAL */)
AND ENTRY.ENTRY_TYPE IN ( 'E'
, /* NORMAL ENTRY */ 'D'
, /* ADDITIONAL ENTRY */ 'S' /* OVERRIDE */ )