VIEW: APPS.PAY_PAYWIEEH_ELEMENT_ENTRIES

Source

View Text - Preformatted

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 */ )

View Text - HTML Formatted

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 */ )