eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PAY_PAYWSMEE_ELEMENT_ENTRIES

Source

View Text - Preformatted


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 */ 'FL' /* FLSA ENTRY */ ) /* 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 */ 'FL' /* FLSA ENTRY */ ) /* 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))

View Text - HTML Formatted

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 */ 'FL' /* FLSA ENTRY */ ) /* 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 */ 'FL' /* FLSA ENTRY */ ) /* 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))