Retrieve Element List - Fusion Payroll

Select
   PETF.BASE_ELEMENT_NAME ElementName,
   PEC.BASE_CLASSIFICATION_NAME Classification,
   PETF.PROCESSING_TYPE PTYPE,
   PELF.ELEMENT_LINK_NAME LinkName 
from
   PAY_ELEMENT_TYPES_F PETF,
   PAY_ELE_CLASSIFICATIONS PEC,
   PAY_ELEMENT_LINKS_F PELF 
where
   PETF.CLASSIFICATION_ID = PEC.CLASSIFICATION_ID 
   AND PETF.ELEMENT_TYPE_ID = PELF.ELEMENT_TYPE_ID 
order by
   PEC.BASE_CLASSIFICATION_NAME,
   PETF.BASE_ELEMENT_NAME asc