SELECT A.RESULT_VALUE , B.ELEMENT_NAME , E.DATE_EARNED , C.PERSON_ID , I.ACTY_BASE_RT_ID FROM PAY_RUN_RESULT_VALUES A , PAY_ELEMENT_TYPES_F B , PER_ASSIGNMENTS_F C , PAY_ASSIGNMENT_ACTIONS D , PAY_PAYROLL_ACTIONS E , PAY_PAYROLLS_F F , PER_TIME_PERIODS G , PAY_RUN_RESULTS H , BEN_ACTY_BASE_RT_F I , PAY_INPUT_VALUES_F J , FND_SESSIONS SE WHERE SE.SESSION_ID = USERENV('SESSIONID') AND C.ASSIGNMENT_ID = D.ASSIGNMENT_ID AND C.PRIMARY_FLAG = 'Y' AND D.PAYROLL_ACTION_ID = E.PAYROLL_ACTION_ID AND C.PAYROLL_ID = F.PAYROLL_ID AND B.ELEMENT_TYPE_ID = J.ELEMENT_TYPE_ID AND J.INPUT_VALUE_ID = I.INPUT_VALUE_ID AND I.ELEMENT_TYPE_ID = B.ELEMENT_TYPE_ID AND SE.EFFECTIVE_DATE BETWEEN F.EFFECTIVE_START_DATE AND F.EFFECTIVE_END_DATE AND F.PAYROLL_ID = G.PAYROLL_ID AND B.ELEMENT_TYPE_ID = H.ELEMENT_TYPE_ID AND D.ASSIGNMENT_ACTION_ID = H.ASSIGNMENT_ACTION_ID AND E.DATE_EARNED BETWEEN G.START_DATE AND G.END_DATE AND A.INPUT_VALUE_ID = J.INPUT_VALUE_ID AND A.RUN_RESULT_ID = H.RUN_RESULT_ID AND SE.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE AND SE.EFFECTIVE_DATE BETWEEN C.EFFECTIVE_START_DATE AND C.EFFECTIVE_END_DATE AND SE.EFFECTIVE_DATE BETWEEN I.EFFECTIVE_START_DATE AND I.EFFECTIVE_END_DATE AND SE.EFFECTIVE_DATE BETWEEN J.EFFECTIVE_START_DATE AND J.EFFECTIVE_END_DATE AND A.RESULT_VALUE IS NOT NULL