VIEW: APPS.HXT_ADD_ELEM_INFO_FMV

Source

View Text - Preformatted

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 ,aei.EXCLUDE_FROM_EXPLOSION 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(+)

View Text - HTML Formatted

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
, AEI.EXCLUDE_FROM_EXPLOSION
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(+)