Query to Fetch Goal Details in Fusion HCM

SELECT papf.person_id,
       paam.assignment_id,
       hgm.measurement_id,
       hgpvl.goal_plan_name                  AS GOAL_PLAN_NAME,
       ppnf.display_name                     AS EMPLOYEE_FULL_NAME,
       papf.person_number                    AS PERSON_NUMBER,
       hg.goal_name                          AS KRA,
       hg.goal_version_type_code             AS GOAL_VERSION_TYPE_CODE,
       TO_CHAR(hg.start_date, 'DD-MM-YYYY')  AS GOAL_START_DATE,
       hg.status_code                        AS STATUS_CODE,
       TO_CHAR(TRUNC(SYSDATE), 'DD-MM-YYYY') AS CURRENT_DATE,
       goal_type_code,
       hg.goal_id,
       hgm.measurement_name                  KPI,
       gpg.weighting
FROM   hrg_goal_plans_vl hgpvl,
       hrg_goals hg,
       hrg_goal_plan_goals gpg,
       per_all_people_f papf,
       per_person_names_f ppnf,
       per_all_assignments_m paam,
       hrg_goal_measurements hgm
WHERE  1 = 1
       AND papf.person_id = paam.person_id
       AND paam.assignment_status_type = 'ACTIVE'
       AND paam.assignment_type = 'E'
       AND paam.primary_flag = 'Y'
       AND paam.effective_latest_change = 'Y'
       AND TRUNC(SYSDATE) BETWEEN paam.effective_start_date AND
                                  paam.effective_end_date
       AND hg.person_id = papf.person_id
       AND hg.person_id = ppnf.person_id
       AND ppnf.name_type = 'GLOBAL'
       AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date AND
                                  papf.effective_end_date
       AND TRUNC(SYSDATE) BETWEEN ppnf.effective_start_date AND
                                  ppnf.effective_end_date
       AND hg.goal_id = gpg.goal_id
       AND hg.goal_type_code = 'PERFORMANCE'
       AND gpg.goal_plan_id = hgpvl.goal_plan_id
       AND hg.status_code NOT IN ( 'COMPLETED' )
       AND TRUNC(SYSDATE) BETWEEN hgpvl.start_date AND hgpvl.end_date
       AND hg.goal_id = hgm.goal_id (+)
       AND TRUNC(SYSDATE) BETWEEN hgm.start_date(+) AND hgm.end_date(+)