GMS Grant accounting Budget Lines sql to extract earliest period

 
 
 
 
 
 
 
 
 
 
 

When I am trying to run following sql which we use to get
earliest budge period in current script  this returns MAR-15 , but I need to get result OCT-15 as per above script.

      

SELECT

                      (CASE

                  WHENMIN(TO_DATE (l.period_name, 'MON-YY')) =

                          TO_DATE ('APR-14', 'MON-YY')

                  THEN

                     'MAY-14'

                  ELSE

                     TO_CHAR (MIN (TO_DATE (l.period_name, 'MON-YY')),

                              'MON-YY')

               END)

                
earliest_budget_period        

          FROM pa.pa_projects_allp,

             
gms.gms_budget_versions v,

             
gms.gms_resource_assignments ra,

             
gms.gms_budget_lines l,

             
PA.PA_RESOURCE_LIST_MEMBERSm

        WHERE    p.PROJECT_ID=
v.PROJECT_ID