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.

[Home] [Help]

View: PAY_PAYE_ELEMENT_ENTRIES_V2

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

View Text

SELECT ASG.BUSINESS_GROUP_ID
, PEO.PERSON_ID
, PEO.FULL_NAME
, PEO.NATIONAL_IDENTIFIER
, ASG.ASSIGNMENT_ID
, ASG.ASSIGNMENT_NUMBER
, PAY.PAYROLL_ID
, PAY.PAYROLL_NAME
, ELE.ELEMENT_ENTRY_ID
, ELE.EFFECTIVE_START_DATE
, ELE.EFFECTIVE_END_DATE
, ELE.COST_ALLOCATION_KEYFLEX_ID
, ELE.UPDATING_ACTION_ID
, ELE.ORIGINAL_ENTRY_ID
, ELE.CREATOR_TYPE
, ELE.COMMENT_ID
, ELE.CREATOR_ID
, ELE.REASON
, ELE.SUBPRIORITY
, ELE.DATE_EARNED
, ELE.PERSONAL_PAYMENT_METHOD_ID
, ELE.ATTRIBUTE_CATEGORY
, ELE.ATTRIBUTE1
, ELE.ATTRIBUTE2
, ELE.ATTRIBUTE3
, ELE.ATTRIBUTE4
, ELE.ATTRIBUTE5
, ELE.ATTRIBUTE6
, ELE.ATTRIBUTE7
, ELE.ATTRIBUTE8
, ELE.ATTRIBUTE9
, ELE.ATTRIBUTE10
, ELE.ATTRIBUTE11
, ELE.ATTRIBUTE12
, ELE.ATTRIBUTE13
, ELE.ATTRIBUTE14
, ELE.ATTRIBUTE15
, ELE.ATTRIBUTE16
, ELE.ATTRIBUTE17
, ELE.ATTRIBUTE18
, ELE.ATTRIBUTE19
, ELE.ATTRIBUTE20
, MIN(DECODE(INV.NAME
, 'TAX CODE'
, EEV.INPUT_VALUE_ID
, NULL)) TAX_CODE_ID
, MIN(DECODE(INV.NAME
, 'TAX CODE'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) TAX_CODE_SV
, MIN(DECODE(INV.NAME
, 'TAX BASIS'
, EEV.INPUT_VALUE_ID
, NULL)) TAX_BASIS_ID
, MIN(DECODE(INV.NAME
, 'TAX BASIS'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) TAX_BASIS_SV
, MIN(DECODE(INV.NAME
, 'PAY PREVIOUS'
, EEV.INPUT_VALUE_ID
, NULL)) PAY_PREVIOUS_ID
, MIN(DECODE(INV.NAME
, 'PAY PREVIOUS'
, EEV.SCREEN_ENTRY_VALUE
, NULL) ) PAY_PREVIOUS_SV
, MIN(DECODE(INV.NAME
, 'TAX PREVIOUS'
, EEV.INPUT_VALUE_ID
, NULL)) TAX_PREVIOUS_ID
, MIN(DECODE(INV.NAME
, 'TAX PREVIOUS'
, EEV.SCREEN_ENTRY_VALUE
, NULL) ) TAX_PREVIOUS_SV
, MIN(DECODE(INV.NAME
, 'AUTHORITY'
, EEV.INPUT_VALUE_ID
, NULL)) AUTHORITY_ID
, MIN(DECODE(INV.NAME
, 'AUTHORITY'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) AUTHORITY_SV
, MIN(DECODE(INV.NAME
, 'REFUNDABLE'
, EEV.INPUT_VALUE_ID
, NULL)) REFUNDABLE_ID
, MIN(DECODE(INV.NAME
, 'REFUNDABLE'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) REFUNDABLE_SV
FROM PER_PEOPLE_F PEO
, PAY_ELEMENT_ENTRY_VALUES_F EEV
, PAY_ELEMENT_ENTRIES_F ELE
, PAY_INPUT_VALUES_F INV
, PAY_ELEMENT_LINKS_F EL
, PAY_ELEMENT_TYPES_F ELT
, FND_SESSIONS SES
, PER_ASSIGNMENTS_F ASG
, PAY_PAYROLLS_F PAY
WHERE SES.SESSION_ID = USERENV('SESSIONID')
AND PEO.PERSON_ID = ASG.PERSON_ID
AND SES.EFFECTIVE_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND ASG.ASSIGNMENT_ID = ELE.ASSIGNMENT_ID
AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG.PAYROLL_ID = PAY.PAYROLL_ID
AND SES.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE
AND ELE.ELEMENT_ENTRY_ID = EEV.ELEMENT_ENTRY_ID
AND SES.EFFECTIVE_DATE BETWEEN ELE.EFFECTIVE_START_DATE
AND ELE.EFFECTIVE_END_DATE
AND EL.ELEMENT_LINK_ID + DECODE(ASG.ASSIGNMENT_ID
, NULL
, 0
, 0) = ELE.ELEMENT_LINK_ID
AND SES.EFFECTIVE_DATE BETWEEN EL.EFFECTIVE_START_DATE
AND EL.EFFECTIVE_END_DATE
AND ELT.ELEMENT_TYPE_ID = EL.ELEMENT_TYPE_ID
AND EEV.INPUT_VALUE_ID + 0 = INV.INPUT_VALUE_ID
AND SES.EFFECTIVE_DATE BETWEEN EEV.EFFECTIVE_START_DATE
AND EEV.EFFECTIVE_END_DATE
AND INV.ELEMENT_TYPE_ID = ELT.ELEMENT_TYPE_ID + DECODE(ELE.ELEMENT_ENTRY_ID
, NULL
, 0
, 0)
AND SES.EFFECTIVE_DATE BETWEEN INV.EFFECTIVE_START_DATE
AND INV.EFFECTIVE_END_DATE
AND ELT.ELEMENT_NAME = 'PAYE DETAILS'
AND SES.EFFECTIVE_DATE BETWEEN ELT.EFFECTIVE_START_DATE
AND ELT.EFFECTIVE_END_DATE GROUP BY ASG.BUSINESS_GROUP_ID
, PEO.PERSON_ID
, PEO.FULL_NAME
, PEO.NATIONAL_IDENTIFIER
, ASG.ASSIGNMENT_ID
, ASG.ASSIGNMENT_NUMBER
, PAY.PAYROLL_ID
, PAY.PAYROLL_NAME
, ELE.ELEMENT_ENTRY_ID
, ELE.EFFECTIVE_START_DATE
, ELE.EFFECTIVE_END_DATE
, ELE.COST_ALLOCATION_KEYFLEX_ID
, ELE.UPDATING_ACTION_ID
, ELE.ORIGINAL_ENTRY_ID
, ELE.CREATOR_TYPE
, ELE.COMMENT_ID
, ELE.CREATOR_ID
, ELE.REASON
, ELE.SUBPRIORITY
, ELE.DATE_EARNED
, ELE.PERSONAL_PAYMENT_METHOD_ID
, ELE.ATTRIBUTE_CATEGORY
, ELE.ATTRIBUTE1
, ELE.ATTRIBUTE2
, ELE.ATTRIBUTE3
, ELE.ATTRIBUTE4
, ELE.ATTRIBUTE5
, ELE.ATTRIBUTE6
, ELE.ATTRIBUTE7
, ELE.ATTRIBUTE8
, ELE.ATTRIBUTE9
, ELE.ATTRIBUTE10
, ELE.ATTRIBUTE11
, ELE.ATTRIBUTE12
, ELE.ATTRIBUTE13
, ELE.ATTRIBUTE14
, ELE.ATTRIBUTE15
, ELE.ATTRIBUTE16
, ELE.ATTRIBUTE17
, ELE.ATTRIBUTE18
, ELE.ATTRIBUTE19
, ELE.ATTRIBUTE20

Columns

Name
BUSINESS_GROUP_ID
PERSON_ID
FULL_NAME
NATIONAL_IDENTIFIER
ASSIGNMENT_ID
ASSIGNMENT_NUMBER
PAYROLL_ID
PAYROLL_NAME
ELEMENT_ENTRY_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
COST_ALLOCATION_KEYFLEX_ID
UPDATING_ACTION_ID
ORIGINAL_ENTRY_ID
CREATOR_TYPE
COMMENT_ID
CREATOR_ID
REASON
SUBPRIORITY
DATE_EARNED
PERSONAL_PAYMENT_METHOD_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
TAX_CODE_ID
TAX_CODE_SV
TAX_BASIS_ID
TAX_BASIS_SV
PAY_PREVIOUS_ID
PAY_PREVIOUS_SV
TAX_PREVIOUS_ID
TAX_PREVIOUS_SV
AUTHORITY_ID
AUTHORITY_SV
REFUNDABLE_ID
REFUNDABLE_SV