How to capture the Actual and Planned Efforts at month level

We are creating a custom report for FP project and need to capture the Actual and Planned Efforts. The efforts should match with the Project Progress History Front end Screen which comes under Manage Financial Project Plan.

Currently we are using the below query but it is not giving correct results for few of the projects

with tot_poc_plan_effort as     

   (select distinct link.project_id ,pt.task_id

    from     

      okc_k_headers_all_b OKCH,     

      pjb_cntrct_proj_links LINK,       

      pjf_tasks_v PT             

    WHERE 1=1

    AND OKCH.version_type         = 'C' 

    and okch.TEMPLATE_YN          = 'N'  

    AND OKCH.sts_code           <> 'CANCELED'