Product: | HXT - Time and Labor |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXT_ADD_ELEM_INFO_FMV |
SELECT AEI.ROWID ROW_ID
, AEI.ID
, AEI.EFFECTIVE_START_DATE
, AEI.EFFECTIVE_END_DATE
, AEI.ELEMENT_TYPE_ID
, PETT.ELEMENT_NAME
, PET.BUSINESS_GROUP_ID ELT_BUS_GRP_ID
, AEI.EARNING_CATEGORY
, FCL1.MEANING EARNING_CATEGORY_NAME
, AEI.ABSENCE_TYPE
, FCL2.MEANING ABSENCE_TYPE_NAME
, AEI.ABSENCE_POINTS
, AEI.POINTS_ASSIGNED
, AEI.PREMIUM_TYPE
, FCL3.MEANING PREMIUM_TYPE_NAME
, AEI.PREMIUM_AMOUNT
, AEI.PROCESSING_ORDER
, AEI.EXPENDITURE_TYPE
, AEI.CREATED_BY
, AEI.CREATION_DATE
, AEI.LAST_UPDATE_DATE
, AEI.LAST_UPDATE_LOGIN
, AEI.LAST_UPDATED_BY
, AEI.ATTRIBUTE_CATEGORY
, AEI.ATTRIBUTE1
, AEI.ATTRIBUTE2
, AEI.ATTRIBUTE3
, AEI.ATTRIBUTE4
, AEI.ATTRIBUTE5
, AEI.ATTRIBUTE6
, AEI.ATTRIBUTE7
, AEI.ATTRIBUTE8
, AEI.ATTRIBUTE9
, AEI.ATTRIBUTE10
, AEI.ATTRIBUTE11
, AEI.ATTRIBUTE12
, AEI.ATTRIBUTE13
, AEI.ATTRIBUTE14
, AEI.ATTRIBUTE15
, AEI.ATTRIBUTE16
, AEI.ATTRIBUTE17
, AEI.ATTRIBUTE18
, AEI.ATTRIBUTE19
, AEI.ATTRIBUTE20
, AEI.ATTRIBUTE21
, AEI.ATTRIBUTE22
, AEI.ATTRIBUTE23
, AEI.ATTRIBUTE24
, AEI.ATTRIBUTE25
, AEI.ATTRIBUTE26
, AEI.ATTRIBUTE27
, AEI.ATTRIBUTE28
, AEI.ATTRIBUTE29
, AEI.ATTRIBUTE30
, PET.LEGISLATION_CODE ELT_LEG_CODE
FROM PA_EXPENDITURE_TYPES_V PXTV
, HR_LOOKUPS FCL3
, HR_LOOKUPS FCL2
, HR_LOOKUPS FCL1
, PAY_ELEMENT_TYPES_F_TL PETT
, PAY_ELEMENT_TYPES_F PET
, HXT_ADD_ELEM_INFO_F AEI
, FND_SESSIONS FSS
WHERE FSS.SESSION_ID = USERENV('SESSIONID')
AND FSS.EFFECTIVE_DATE BETWEEN AEI.EFFECTIVE_START_DATE
AND AEI.EFFECTIVE_END_DATE
AND AEI.ELEMENT_TYPE_ID = PET.ELEMENT_TYPE_ID
AND PETT.ELEMENT_TYPE_ID(+) = PET.ELEMENT_TYPE_ID
AND DECODE(PETT.ELEMENT_TYPE_ID
, NULL
, '1'
, PETT.LANGUAGE) = DECODE(PETT.ELEMENT_TYPE_ID
, NULL
, '1'
, USERENV('LANG'))
AND FSS.EFFECTIVE_DATE BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND AEI.EARNING_CATEGORY = FCL1.LOOKUP_CODE
AND FCL1.APPLICATION_ID = 808
AND FCL1.LOOKUP_TYPE = 'HXT_EARNING_CATEGORY'
AND FCL1.ENABLED_FLAG = 'Y'
AND AEI.ABSENCE_TYPE = FCL2.LOOKUP_CODE(+)
AND FCL2.APPLICATION_ID(+) = 808
AND FCL2.LOOKUP_TYPE(+) = 'HXT_ABSENCE_TYPES'
AND FCL2.ENABLED_FLAG(+) = 'Y'
AND AEI.PREMIUM_TYPE = FCL3.LOOKUP_CODE(+)
AND FCL3.APPLICATION_ID(+) = 808
AND FCL3.LOOKUP_TYPE(+) = 'HXT_PREMIUM_TYPE'
AND FCL3.ENABLED_FLAG(+) = 'Y'
AND AEI.EXPENDITURE_TYPE = PXTV.EXPENDITURE_TYPE(+)