Balance Type (Year to Date, Project to Date, Period to Date and Quarter to Date)in Oracle General Ledger

SELECT lookup_code, meaning, description, REPLACE(description, '-', ' ') balance_type

  FROM fnd_lookup_values

 WHERE 1 = 1 

    AND lookup_type = 'PTD_YTD'

    AND language = USERENV('LANG')