Need a query for a date parameter dependent to another date parameter.

Content

Hello all,

There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter should be dependent on the data range. Below mentioned is a part of my main query.

------------------------------------------------------ month name parameter 
    AND ( TO_CHAR(
        DFLA.ACTUAL_SHIP_DATE,
        'MONTH'
    ) IN ( :PMONTH )
          OR 'All' IN ( :PMONTH || 'All' ) )

------------------------------------------------------ date range parameter 
    AND TO_CHAR(
        DFLA.ACTUAL_SHIP_DATE,
        'YYYY-MM-DD'
    ) BETWEEN TO_CHAR(
        :PFROMDATE,
        'YYYY-MM-DD'
    ) AND TO_CHAR(
        :PTODATE,
        'YYYY-MM-DD'
    )

 

For the month name parameter, I have created a LOV,

 

SELECT
    TO_CHAR(
        ADD_MONTHS(