View: PQP_VEHICLE_TEMPLATE_V

Product:	PQP - Public Sector Payroll
Description:	View of all base elements created by the car and mileage element template.
Implementation/DBA Data:	APPS.PQP_VEHICLE_TEMPLATE_V

View Text

SELECT PETF.ELEMENT_TYPE_ID
, PETF.BUSINESS_GROUP_ID
, PETF.LEGISLATION_CODE
, PETF.CLASSIFICATION_ID
, PETF.ELEMENT_NAME
, PETF.DESCRIPTION
, PETF.REPORTING_NAME
, PETEI.EEI_INFORMATION1
, PETF.EFFECTIVE_START_DATE
, PETF.EFFECTIVE_END_DATE
, PETF.LAST_UPDATE_DATE
, PETF.LAST_UPDATED_BY
, PETF.LAST_UPDATE_LOGIN
, PETF.CREATED_BY
, PETF.CREATION_DATE
FROM PAY_ELEMENT_TYPES_F PETF
, PAY_ELEMENT_TYPE_EXTRA_INFO PETEI
WHERE PETF.ELEMENT_TYPE_ID = PETEI.ELEMENT_TYPE_ID
AND PETEI.INFORMATION_TYPE ='PQP_VEHICLE_MILEAGE_INFO'
AND EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT SE.EFFECTIVE_DATE
FROM FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('SESSIONID'))

Columns