Employee Gosi Subscription Status report

Summary: I am working on Employee Gosi Subscription Status report. I need to fetch column Gosi Registered Salary, Employer Contribution and Subscription Status. I am using below query but not able to get data for these columns. Could you please help me out here.

SELECT
ppnf.full_name AS employee_name,
papf.person_number,
hou.name AS department,
pos.name AS position,

-- Basic Salary

MAX(CASE WHEN csc.component_code = 'ORA_BASIC'

         THEN csc.amount END) AS basic_salary,


-- Housing Allowance

MAX(CASE WHEN csc.component_code = 'ORA_HOUSING_ALLOWANCE'

         THEN csc.amount END) AS housing_allowance,


-- Transport Allowance