View: PAY_PAYE_ELEMENT_ENTRIES_V

Product:	PAY - Payroll
Description:	View based on PAY_ELEMENT_ENTRY_VALUES_F used in the PAYGBTAX form to display PAYE details.
Implementation/DBA Data:	APPS.PAY_PAYE_ELEMENT_ENTRIES_V

View Text

SELECT ELE.ROWID ROW_ID
, ELE.ELEMENT_ENTRY_ID
, MIN(DECODE(INV.NAME
, 'TAX CODE'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID1
, MIN(DECODE(INV.NAME
, 'TAX CODE'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) TAX_CODE
, MIN(DECODE(INV.NAME
, 'TAX BASIS'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID2
, MIN(DECODE(INV.NAME
, 'TAX BASIS'
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS'
, EEV.SCREEN_ENTRY_VALUE)
, 1
, 80)
, NULL)) D_TAX_BASIS
, MIN(DECODE(INV.NAME
, 'TAX BASIS'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) TAX_BASIS
, MIN(DECODE(INV.NAME
, 'REFUNDABLE'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID3
, MIN(DECODE(INV.NAME
, 'REFUNDABLE'
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('GB_REFUNDABLE'
, EEV.SCREEN_ENTRY_VALUE)
, 1
, 80)
, NULL)) D_REFUNDABLE
, MIN(DECODE(INV.NAME
, 'REFUNDABLE'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) REFUNDABLE
, MIN(DECODE(INV.NAME
, 'PAY PREVIOUS'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID4
, HR_CHKFMT.CHANGEFORMAT(NVL(MIN(DECODE(INV.NAME
, 'PAY PREVIOUS'
, EEV.SCREEN_ENTRY_VALUE
, NULL))
, 0)
, 'M'
, 'GBP') D_PAY_PREVIOUS
, MIN(DECODE(INV.NAME
, 'PAY PREVIOUS'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) PAY_PREVIOUS
, MIN(DECODE(INV.NAME
, 'TAX PREVIOUS'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID5
, HR_CHKFMT.CHANGEFORMAT(NVL(MIN(DECODE(INV.NAME
, 'TAX PREVIOUS'
, EEV.SCREEN_ENTRY_VALUE
, NULL))
, 0)
, 'M'
, 'GBP') D_TAX_PREVIOUS
, MIN(DECODE(INV.NAME
, 'TAX PREVIOUS'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) TAX_PREVIOUS
, MIN(DECODE(INV.NAME
, 'AUTHORITY'
, EEV.INPUT_VALUE_ID
, NULL)) INPUT_VALUE_ID6
, MIN(DECODE(INV.NAME
, 'AUTHORITY'
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('GB_AUTHORITY'
, EEV.SCREEN_ENTRY_VALUE)
, 1
, 80)
, NULL)) D_AUTHORITY
, MIN(DECODE(INV.NAME
, 'AUTHORITY'
, EEV.SCREEN_ENTRY_VALUE
, NULL)) AUTHORITY
, ELE.ASSIGNMENT_ID
, ELE.EFFECTIVE_START_DATE
, ELE.EFFECTIVE_END_DATE
, ELE.ENTRY_INFORMATION_CATEGORY
, ELE.ENTRY_INFORMATION1
, ELE.ENTRY_INFORMATION2
FROM PAY_ELEMENT_ENTRIES_F ELE
, PAY_ELEMENT_ENTRY_VALUES_F EEV
, PAY_INPUT_VALUES_F INV
, PAY_ELEMENT_LINKS_F LNK
, PAY_ELEMENT_TYPES_F ELT
, FND_SESSIONS SES
WHERE SES.SESSION_ID = USERENV('SESSIONID')
AND ELE.ELEMENT_ENTRY_ID = EEV.ELEMENT_ENTRY_ID
AND SES.EFFECTIVE_DATE BETWEEN ELE.EFFECTIVE_START_DATE
AND ELE.EFFECTIVE_END_DATE
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
AND SES.EFFECTIVE_DATE BETWEEN INV.EFFECTIVE_START_DATE
AND INV.EFFECTIVE_END_DATE
AND ELE.ELEMENT_LINK_ID = LNK.ELEMENT_LINK_ID
AND ELT.ELEMENT_TYPE_ID = LNK.ELEMENT_TYPE_ID
AND SES.EFFECTIVE_DATE BETWEEN LNK.EFFECTIVE_START_DATE
AND LNK.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 ELE.ROWID
, ELE.ELEMENT_ENTRY_ID
, ELE.ASSIGNMENT_ID
, ELE.ENTRY_INFORMATION_CATEGORY
, ELE.ENTRY_INFORMATION1
, ELE.ENTRY_INFORMATION2
, ELE.EFFECTIVE_START_DATE
, ELE.EFFECTIVE_END_DATE

Columns