Payroll register dynamic BI report

I have a requirement to get the below records in payroll register report(dynamically).

Person Number|<All Earning element names in that particular month (dynamically without hardcoding) >| <All Deduction element names in that particular month (dynamically without hardcoding)>
1|earning element run result values| deduction element run result values

In generally each person will have different elements processed depends on their eligibility or leaves taken. So, all unique earning elements processed based on all persons should come first after deduction elements. In rows if that element processed for the person should come value otherwise zero.

SELECT
papf.person_id,
ptp.end_Date payroll_period,