Query to get Payroll Element Entry information in Fusion HCM

 SELECT DISTINCT B.ELEMENT_NAME ELEMENT_NAME

,A.EFFECTIVE_START_DATE EE_EFFECTIVE_START_DATE

,A.EFFECTIVE_END_DATE EE_EFFECTIVE_END_DATE

,D.NAME INPUT_VALUE_NAME

,C.SCREEN_ENTRY_VALUE DISPLAY_INPUT_VALUE

,A.PERSON_ID

from PAY_ELEMENT_ENTRIES_F A,

PAY_ELEMENT_TYPES_TL B,

PAY_ELEMENT_ENTRY_VALUES_F C,

PAY_INPUT_VALUES_TL D

Where  A.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID

AND B.LANGUAGE = 'US' 

AND A.ELEMENT_ENTRY_ID = C.ELEMENT_ENTRY_ID

AND C.INPUT_VALUE_ID = D.INPUT_VALUE_ID

AND D.LANGUAGE = 'US'

AND D.NAME IN (:P_INPUT_VALUE_NAME)

AND B.ELEMENT_NAME IN (:P_ELEMENT_NAME)

AND A.EFFECTIVE_START_DATE BETWEEN :P_START_DATE AND :P_END_DATE

ORDER BY PERSON_ID,ELEMENT_NAME,EE_EFFECTIVE_START_DATE,EE_EFFECTIVE_END_DATE