PA Interfaced CIP/RWIP Amounts by FA Period

SELECT
       pt.project_type                         r_project_type
      ,ppa.fa_period_name                r_period_name
      ,p.segment1                               r_project_number
      ,p.name                                      r_project_name
       ,decode(:p_group_by_cat,
                     'Y',fnd_flex_ext.get_segs('OFA',
                                                                  'CAT#',
                                                                   101,
                                                                   ppa.asset_category_id),
                            ppa.asset_name)r_column_1
      ,decode(:p_group_by_cat,
                    'Y',ppa.asset_name
                         ,fnd_flex_ext.get_segs('OFA',
                                                                  'CAT#',
                                                                   101,
                                                                    ppa.asset_category_id))r_column_2
      ,pal.description                          r_description
      ,fnd_flex_ext.get_segs('SQLGL','GL#',:cp_coa_id,pal.cip_ccid)  r_cip_ccid
      ,pal.&lp_pa_curr_asset_cost	 r_current_asset_cost
      ,pal.capital_event_id                 r_capital_event_id
FROM
       &lp_pa_proj_asset_line pal,
       pa_projects p,
       pa_project_types pt,
       pa_project_assets ppa,
       gl_code_combinations cc,
       fa_deprn_periods fap
WHERE
       pal.cip_ccid=cc.code_combination_id
 AND  pal.project_id = p.project_id
  AND  pal.line_type='R'
  AND  pal.project_asset_id = ppa.project_asset_id
  AND  p.project_type = pt.project_type
  AND    pal.transfer_status_code ='T'
  AND  fap.book_type_code = ppa.book_type_code
  AND  pal.fa_period_name =fap.period_name
  AND  fap.calendar_period_open_date >= nvl(:cp_min_open_date,fap.calendar_period_open_date) /* Bug 21891438 */
  AND  NVL(fap.calendar_period_close_date,TRUNC(SYSDATE)) <=  NVL(nvl(:cp_max_close_date,fap.calendar_period_close_date),TRUNC(SYSDATE)) /*Added for bug 16816473 */
   AND     (:p_class_category IS NULL  OR
                p.project_id in ( SELECT   project_id
                                          FROM     pa_project_classes
                                          WHERE   class_category = :p_class_category) )
  AND   (:p_class_category IS NULL   OR
              :p_class_code        IS NULL   OR
               p.project_id in  ( SELECT    project_id
                                         FROM       pa_project_classes
                                         WHERE    class_category = :p_class_category
                                          AND        class_code = :p_class_code))
  AND  nvl(:p_project_type,pt.project_type)=pt.project_type
  AND  nvl(:p_project_id,p.project_id)=p.project_id
  AND  nvl (:p_project_org,p.carrying_out_organization_id)   =
            p.carrying_out_organization_id
 AND  &c_where
AND &c_sob_id
ORDER BY 2 ASC,1 ASC,3 ASC,4 ASC,5 ASC