View: PAY_PAYWSMEE_ELEMENT_ENTRIES

Product:	PAY - Payroll
Description:	Base view of the element entries block for the form PAYWSMEE.
Implementation/DBA Data:	APPS.PAY_PAYWSMEE_ELEMENT_ENTRIES

View Text

SELECT ENTRY.ELEMENT_ENTRY_ID
, ENTRY.ASSIGNMENT_ID
, ENTRY.EFFECTIVE_START_DATE
, ENTRY.EFFECTIVE_END_DATE
, ENTRY.COST_ALLOCATION_KEYFLEX_ID
, ENTRY.UPDATING_ACTION_ID
, ENTRY.ELEMENT_LINK_ID
, ENTRY.ORIGINAL_ENTRY_ID
, ENTRY.CREATOR_TYPE
, ENTRY.ENTRY_TYPE
, DECODE (ENTRY.ENTRY_TYPE
, 'D'
, 'Y'
, 'N')
, DECODE (ENTRY.ENTRY_TYPE
, 'S'
, 'Y'
, 'N')
, ENTRY.COMMENT_ID
, ENTRY.CREATOR_ID
, ENTRY.REASON
, HR_GENERAL.DECODE_LOOKUP ('ELE_ENTRY_REASON'
, ENTRY.REASON)
, ENTRY.TARGET_ENTRY_ID
, 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
, SUBSTR (ELEMENT.PROCESSING_TYPE
, 1
, 1)
, HR_GENERAL.DECODE_LOOKUP ('PROCESSING_TYPE'
, ELEMENT.PROCESSING_TYPE)
, ELEMENT.PROCESSING_PRIORITY
, SUBSTR (ELEMENT.PROCESS_IN_RUN_FLAG
, 1
, 1)
, SUBSTR (ELEMENT.CLOSED_FOR_ENTRY_FLAG
, 1
, 1)
, SUBSTR (ELEMENT.ADDITIONAL_ENTRY_ALLOWED_FLAG
, 1
, 1)
, SUBSTR (ELEMENT.MULTIPLE_ENTRIES_ALLOWED_FLAG
, 1
, 1)
, ELEMENT.INPUT_CURRENCY_CODE
, SUBSTR (PAY_PAYWSMEE_PKG.OVERRIDDEN (LINK.ELEMENT_LINK_ID
, ENTRY.ASSIGNMENT_ID
, SESH.EFFECTIVE_DATE)
, 1
, 1)
, SUBSTR (PAY_PAYWSMEE_PKG.ADJUSTED (LINK.ELEMENT_LINK_ID
, ENTRY.ASSIGNMENT_ID
, SESH.EFFECTIVE_DATE)
, 1
, 1)
, SUBSTR (PAY_PAYWSMEE_PKG.PROCESSED (ENTRY.ELEMENT_ENTRY_ID
, ENTRY.ORIGINAL_ENTRY_ID
, ELEMENT.PROCESSING_TYPE
, ENTRY.ENTRY_TYPE
, SESH.EFFECTIVE_DATE)
, 1
, 1)
, DECODE(NVL(ENTRY_PROC.SOURCE_ASG_ACTION_ID
, -1)
, -1
, 'N'
, 'Y') RETROACTIVE
, ELEMENT.CLASSIFICATION_ID
, SUBSTR (LINK.COSTABLE_TYPE
, 1
, 1)
, ENTRY.SUBPRIORITY
, BENEFIT.CONTRIBUTIONS_USED
, ENTRY.CREATION_DATE
, ENTRY.CREATED_BY
, ENTRY.LAST_UPDATE_LOGIN
, ENTRY.LAST_UPDATED_BY
, ENTRY.LAST_UPDATE_DATE
, ENTRY.DATE_EARNED
, PAY_PAYWSMEE_PKG.GET_ORIGINAL_DATE_EARNED(ENTRY.ELEMENT_ENTRY_ID) ORIGINAL_DATE_EARNED
, ENTRY.PERSONAL_PAYMENT_METHOD_ID
, SUBSTR (PAY_PAYWSMEE_PKG.PERSONAL_PAYMENT_METHOD ( ENTRY.PERSONAL_PAYMENT_METHOD_ID
, ENTRY.ASSIGNMENT_ID
, SESH.EFFECTIVE_DATE)
, 1
, 255)
, ELEMENT.THIRD_PARTY_PAY_ONLY_FLAG
, ENTRY.ROWID ROW_ID
, ENTRY.ENTRY_INFORMATION_CATEGORY
, ENTRY.ENTRY_INFORMATION1
, ENTRY.ENTRY_INFORMATION2
, ENTRY.ENTRY_INFORMATION3
, ENTRY.ENTRY_INFORMATION4
, ENTRY.ENTRY_INFORMATION5
, ENTRY.ENTRY_INFORMATION6
, ENTRY.ENTRY_INFORMATION7
, ENTRY.ENTRY_INFORMATION8
, ENTRY.ENTRY_INFORMATION9
, ENTRY.ENTRY_INFORMATION10
, ENTRY.ENTRY_INFORMATION11
, ENTRY.ENTRY_INFORMATION12
, ENTRY.ENTRY_INFORMATION13
, ENTRY.ENTRY_INFORMATION14
, ENTRY.ENTRY_INFORMATION15
, ENTRY.ENTRY_INFORMATION16
, ENTRY.ENTRY_INFORMATION17
, ENTRY.ENTRY_INFORMATION18
, ENTRY.ENTRY_INFORMATION19
, ENTRY.ENTRY_INFORMATION20
, ENTRY.ENTRY_INFORMATION21
, ENTRY.ENTRY_INFORMATION22
, ENTRY.ENTRY_INFORMATION23
, ENTRY.ENTRY_INFORMATION24
, ENTRY.ENTRY_INFORMATION25
, ENTRY.ENTRY_INFORMATION26
, ENTRY.ENTRY_INFORMATION27
, ENTRY.ENTRY_INFORMATION28
, ENTRY.ENTRY_INFORMATION29
, ENTRY.ENTRY_INFORMATION30
, -999999999999999 FROM PAY_ELEMENT_TYPES_F_TL ELEMENTTL
, PAY_ELEMENT_TYPES_F ELEMENT
, BEN_BENEFIT_CLASSIFICATIONS BENEFIT
, PAY_ELEMENT_ENTRIES_F ENTRY
, PAY_ELEMENT_LINKS_F LINK
, PAY_ENTRY_PROCESS_DETAILS ENTRY_PROC
, FND_SESSIONS SESH /* TABLE JOINS */
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.ELEMENT_ENTRY_ID = ENTRY_PROC.ELEMENT_ENTRY_ID (+) /* ONLY DISPLAY ENTRIES FOR CERTAIN SUB-SYSTEMS */
AND ENTRY.CREATOR_TYPE IN ( 'H'
, /* MIX */ 'P'
, /* BACKPAY */ 'SP'
, /* SALARY PROPOSAL */ 'F'
, /* OTHER */ 'M'
, /* STATUTORY MATERNITY PAY */ 'S'
, /* STATUTORY SICK PAY */ 'A'
, /* ABSENCE */ 'D'
, /* ADVANCE PAY */ 'DF'
, /* ADVANCE PAY FORM */ 'R'
, /* RETROPAY BY ACTION */ 'EE'
, /* RETROPAY/ELEMENT EE */ 'RR'
, /* RETROPAY/ELEMENT RR */ 'AD'
, /* ADVANCEPAY/ELEMENT AD */ 'AE'
, /* ADVANCEPAY/ELEMENT AE */ 'PR'
, /* RETROPAY ELEMENT PR */ 'NR' /* RETROPAY/ELEMENT NR */ ) /* ONLY DISPLAY ENTRIES OF CERTAIN TYPES */
AND ENTRY.ENTRY_TYPE IN ( 'E'
, /* NORMAL ENTRY */ 'S'
, /* OVERRIDE */ 'D' /* ADDITIONAL */ ) /* ONLY DISPLAY ENTRIES CURRENT AS OF EFFECTIVE DATE */
AND USERENV ('SESSIONID') = SESH.SESSION_ID
AND SESH.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE
AND ELEMENT.EFFECTIVE_END_DATE
AND SESH.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE
AND LINK.EFFECTIVE_END_DATE
AND SESH.EFFECTIVE_DATE BETWEEN ENTRY.EFFECTIVE_START_DATE
AND ENTRY.EFFECTIVE_END_DATE UNION ALL SELECT DISTINCT ENTRY.ELEMENT_ENTRY_ID
, ENTRY.ASSIGNMENT_ID
, ENTRY.EFFECTIVE_START_DATE
, ENTRY.EFFECTIVE_END_DATE
, ENTRY.COST_ALLOCATION_KEYFLEX_ID
, ENTRY.UPDATING_ACTION_ID
, ENTRY.ELEMENT_LINK_ID
, ENTRY.ORIGINAL_ENTRY_ID
, ENTRY.CREATOR_TYPE
, ENTRY.ENTRY_TYPE
, DECODE (ENTRY.ENTRY_TYPE
, 'D'
, 'Y'
, 'N')
, DECODE (ENTRY.ENTRY_TYPE
, 'S'
, 'Y'
, 'N')
, ENTRY.COMMENT_ID
, ENTRY.CREATOR_ID
, ENTRY.REASON
, HR_GENERAL.DECODE_LOOKUP ('ELE_ENTRY_REASON'
, ENTRY.REASON)
, ENTRY.TARGET_ENTRY_ID
, 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
, SUBSTR (ELEMENT.PROCESSING_TYPE
, 1
, 1)
, HR_GENERAL.DECODE_LOOKUP ('PROCESSING_TYPE'
, ELEMENT.PROCESSING_TYPE)
, ELEMENT.PROCESSING_PRIORITY
, SUBSTR (ELEMENT.PROCESS_IN_RUN_FLAG
, 1
, 1)
, SUBSTR (ELEMENT.CLOSED_FOR_ENTRY_FLAG
, 1
, 1)
, SUBSTR (ELEMENT.ADDITIONAL_ENTRY_ALLOWED_FLAG
, 1
, 1)
, SUBSTR (ELEMENT.MULTIPLE_ENTRIES_ALLOWED_FLAG
, 1
, 1)
, ELEMENT.INPUT_CURRENCY_CODE
, SUBSTR (PAY_PAYWSMEE_PKG.OVERRIDDEN (LINK.ELEMENT_LINK_ID
, ENTRY.ASSIGNMENT_ID
, SESH.EFFECTIVE_DATE)
, 1
, 1)
, SUBSTR (PAY_PAYWSMEE_PKG.ADJUSTED (LINK.ELEMENT_LINK_ID
, ENTRY.ASSIGNMENT_ID
, SESH.EFFECTIVE_DATE)
, 1
, 1)
, SUBSTR (PAY_PAYWSMEE_PKG.PROCESSED (ENTRY.ELEMENT_ENTRY_ID
, ENTRY.ORIGINAL_ENTRY_ID
, ELEMENT.PROCESSING_TYPE
, ENTRY.ENTRY_TYPE
, SESH.EFFECTIVE_DATE)
, 1
, 1)
, DECODE(NVL(ENTRY_PROC.SOURCE_ASG_ACTION_ID
, -1)
, -1
, 'N'
, 'Y') RETROACTIVE
, ELEMENT.CLASSIFICATION_ID
, SUBSTR (LINK.COSTABLE_TYPE
, 1
, 1)
, ENTRY.SUBPRIORITY
, BENEFIT.CONTRIBUTIONS_USED
, ENTRY.CREATION_DATE
, ENTRY.CREATED_BY
, ENTRY.LAST_UPDATE_LOGIN
, ENTRY.LAST_UPDATED_BY
, ENTRY.LAST_UPDATE_DATE
, ENTRY.DATE_EARNED
, PAY_PAYWSMEE_PKG.GET_ORIGINAL_DATE_EARNED(ENTRY.ELEMENT_ENTRY_ID) ORIGINAL_DATE_EARNED
, ENTRY.PERSONAL_PAYMENT_METHOD_ID
, SUBSTR (PAY_PAYWSMEE_PKG.PERSONAL_PAYMENT_METHOD ( ENTRY.PERSONAL_PAYMENT_METHOD_ID
, ENTRY.ASSIGNMENT_ID
, SESH.EFFECTIVE_DATE)
, 1
, 255)
, ELEMENT.THIRD_PARTY_PAY_ONLY_FLAG
, ENTRY.ROWID ROW_ID
, ENTRY.ENTRY_INFORMATION_CATEGORY
, ENTRY.ENTRY_INFORMATION1
, ENTRY.ENTRY_INFORMATION2
, ENTRY.ENTRY_INFORMATION3
, ENTRY.ENTRY_INFORMATION4
, ENTRY.ENTRY_INFORMATION5
, ENTRY.ENTRY_INFORMATION6
, ENTRY.ENTRY_INFORMATION7
, ENTRY.ENTRY_INFORMATION8
, ENTRY.ENTRY_INFORMATION9
, ENTRY.ENTRY_INFORMATION10
, ENTRY.ENTRY_INFORMATION11
, ENTRY.ENTRY_INFORMATION12
, ENTRY.ENTRY_INFORMATION13
, ENTRY.ENTRY_INFORMATION14
, ENTRY.ENTRY_INFORMATION15
, ENTRY.ENTRY_INFORMATION16
, ENTRY.ENTRY_INFORMATION17
, ENTRY.ENTRY_INFORMATION18
, ENTRY.ENTRY_INFORMATION19
, ENTRY.ENTRY_INFORMATION20
, ENTRY.ENTRY_INFORMATION21
, ENTRY.ENTRY_INFORMATION22
, ENTRY.ENTRY_INFORMATION23
, ENTRY.ENTRY_INFORMATION24
, ENTRY.ENTRY_INFORMATION25
, ENTRY.ENTRY_INFORMATION26
, ENTRY.ENTRY_INFORMATION27
, ENTRY.ENTRY_INFORMATION28
, ENTRY.ENTRY_INFORMATION29
, ENTRY.ENTRY_INFORMATION30
, ASSACT.ASSIGNMENT_ACTION_ID FROM PAY_ELEMENT_TYPES_F_TL ELEMENTTL
, PAY_ELEMENT_TYPES_F ELEMENT
, BEN_BENEFIT_CLASSIFICATIONS BENEFIT
, PAY_ELEMENT_ENTRIES_F ENTRY
, PAY_ELEMENT_LINKS_F LINK
, PAY_ENTRY_PROCESS_DETAILS ENTRY_PROC
, PAY_ASSIGNMENT_ACTIONS ASSACT
, PAY_PAYROLL_ACTIONS PAYACT
, FND_SESSIONS SESH /* TABLE JOINS */
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.ELEMENT_ENTRY_ID = ENTRY_PROC.ELEMENT_ENTRY_ID (+) /* ONLY DISPLAY ENTRIES FOR CERTAIN SUB-SYSTEMS */
AND ENTRY.CREATOR_TYPE IN ( 'H'
, /* MIX */ 'P'
, /* BACKPAY */ 'SP'
, /* SALARY PROPOSAL */ 'F'
, /* OTHER */ 'M'
, /* STATUTORY MATERNITY PAY */ 'S'
, /* STATUTORY SICK PAY */ 'A'
, /* ABSENCE */ 'D'
, /* ADVANCE PAY */ 'DF'
, /* ADVANCE PAY FORM */ 'R'
, /* RETROPAY BY ACTION */ 'EE'
, /* RETROPAY/ELEMENT EE */ 'RR'
, /* RETROPAY/ELEMENT RR */ 'AD'
, /* ADVANCEPAY/ELEMENT AD */ 'AE'
, /* ADVANCEPAY/ELEMENT AE */ 'PR'
, /* RETROPAY ELEMENT PR */ 'NR' /* RETROPAY/ELEMENT NR */ ) /* ONLY DISPLAY ENTRIES OF CERTAIN TYPES */
AND ENTRY.ENTRY_TYPE IN ( 'E'
, /* NORMAL ENTRY */ 'S'
, /* OVERRIDE */ 'D' /* ADDITIONAL */ ) /* ONLY DISPLAY ENTRIES CURRENT AS OF EFFECTIVE DATE */
AND USERENV ('SESSIONID') = SESH.SESSION_ID
AND SESH.EFFECTIVE_DATE BETWEEN ELEMENT.EFFECTIVE_START_DATE
AND ELEMENT.EFFECTIVE_END_DATE
AND SESH.EFFECTIVE_DATE BETWEEN LINK.EFFECTIVE_START_DATE
AND LINK.EFFECTIVE_END_DATE
AND ENTRY.ASSIGNMENT_ID = ASSACT.ASSIGNMENT_ID
AND ASSACT.PAYROLL_ACTION_ID = PAYACT.PAYROLL_ACTION_ID
AND PAYACT.DATE_EARNED BETWEEN ELEMENT.EFFECTIVE_START_DATE
AND ELEMENT.EFFECTIVE_END_DATE
AND PAYACT.DATE_EARNED BETWEEN LINK.EFFECTIVE_START_DATE
AND LINK.EFFECTIVE_END_DATE
AND ENTRY.EFFECTIVE_START_DATE <= PAYACT.DATE_EARNED
AND ENTRY.EFFECTIVE_END_DATE >= DECODE(ELEMENT.PRORATION_GROUP_ID
, NULL
, PAYACT.DATE_EARNED
, PAY_INTERPRETER_PKG.PRORATE_START_DATE(ASSACT.ASSIGNMENT_ACTION_ID
, ELEMENT.PRORATION_GROUP_ID))

Columns