View: SSP_SSP_ENTRIES_V

Product:	SSP - SSP
Description:	Nonrecurring entries for SSP and SSP correction elements.
Implementation/DBA Data:	APPS.SSP_SSP_ENTRIES_V

View Text

SELECT DECODE (ELT.ELEMENT_NAME
, 'STATUTORY SICK PAY'
, 'N'
, 'Y')
, ELE.ASSIGNMENT_ID
, PAF.PERSON_ID
, ELE.ELEMENT_LINK_ID
, ELE.ELEMENT_ENTRY_ID
, ELE.TARGET_ENTRY_ID
, FND_DATE.CANONICAL_TO_DATE (MIN(DECODE (PIV.NAME
, 'FROM'
, EEV.SCREEN_ENTRY_VALUE
, NULL)))
, FND_DATE.CANONICAL_TO_DATE (MIN(DECODE (PIV.NAME
, 'TO'
, EEV.SCREEN_ENTRY_VALUE
, NULL)))
, FND_NUMBER.CANONICAL_TO_NUMBER (MIN(DECODE (PIV.NAME
, 'AMOUNT'
, EEV.SCREEN_ENTRY_VALUE
, NULL)))
, FND_NUMBER.CANONICAL_TO_NUMBER (MIN(DECODE (PIV.NAME
, 'RATE'
, EEV.SCREEN_ENTRY_VALUE
, NULL)))
, FND_NUMBER.CANONICAL_TO_NUMBER (MIN(DECODE (PIV.NAME
, 'QUALIFYING DAYS'
, EEV.SCREEN_ENTRY_VALUE
, NULL)))
, FND_NUMBER.CANONICAL_TO_NUMBER (MIN(DECODE (PIV.NAME
, 'SSP DAYS DUE'
, EEV.SCREEN_ENTRY_VALUE
, NULL)))
, FND_NUMBER.CANONICAL_TO_NUMBER (MIN(DECODE (PIV.NAME
, 'WITHHELD DAYS'
, EEV.SCREEN_ENTRY_VALUE
, NULL)))
, FND_NUMBER.CANONICAL_TO_NUMBER (MIN(DECODE (PIV.NAME
, 'SSP WEEKS'
, EEV.SCREEN_ENTRY_VALUE
, NULL)))
, ELE.CREATOR_ID
, ELE.EFFECTIVE_START_DATE
, ELE.EFFECTIVE_END_DATE
, MIN (DECODE (PIV.NAME
, 'FROM'
, PIV.ROWID
, NULL)) ROW_ID
FROM PAY_ELEMENT_ENTRY_VALUES_F EEV
, PAY_ELEMENT_ENTRIES_F ELE
, PAY_INPUT_VALUES_F PIV
, PAY_ELEMENT_TYPES_F ELT
, PER_ASSIGNMENTS_F PAF
WHERE ELE.CREATOR_TYPE = 'S'
AND ELE.ELEMENT_ENTRY_ID = EEV.ELEMENT_ENTRY_ID
AND EEV.INPUT_VALUE_ID = PIV.INPUT_VALUE_ID
AND EEV.EFFECTIVE_START_DATE BETWEEN ELT.EFFECTIVE_START_DATE
AND ELT.EFFECTIVE_END_DATE
AND EEV.EFFECTIVE_START_DATE BETWEEN PIV.EFFECTIVE_START_DATE
AND PIV.EFFECTIVE_END_DATE
AND ELT.ELEMENT_NAME IN ('SSP CORRECTIONS'
, 'STATUTORY SICK PAY')
AND PAF.ASSIGNMENT_ID = ELE.ASSIGNMENT_ID
AND EEV.EFFECTIVE_START_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND EXISTS (SELECT 1
FROM PAY_ELEMENT_LINKS_F PEL
WHERE ELT.ELEMENT_TYPE_ID = PEL.ELEMENT_TYPE_ID
AND PEL.ELEMENT_LINK_ID = ELE.ELEMENT_LINK_ID
AND EEV.EFFECTIVE_START_DATE BETWEEN PEL.EFFECTIVE_START_DATE
AND PEL.EFFECTIVE_END_DATE) GROUP BY DECODE (ELT.ELEMENT_NAME
, 'STATUTORY SICK PAY'
, 'N'
, 'Y')
, ELE.ASSIGNMENT_ID
, PAF.PERSON_ID
, ELE.ELEMENT_ENTRY_ID
, ELE.EFFECTIVE_START_DATE
, ELE.EFFECTIVE_END_DATE
, ELE.CREATOR_ID
, ELE.ELEMENT_LINK_ID
, ELE.TARGET_ENTRY_ID

Columns