Query to get Position Details in Oracle APPS

  SELECT name position_name,

         org_name,

         job_name,

         location_code,

         TO_CHAR(date_effective, 'DD-MON-RRRR') date_effective,

        TO_CHAR(date_end, 'DD-MON-RRRR') date_end 

    FROM per_positions_v 

   WHERE 1 = 1

         AND TRUNC (creation_date) BETWEEN TO_DATE ('01-JAN-2021',

                                                    'DD-MON-RRRR')

                                       AND TO_DATE ('31-DEC-2021',

                                                    'DD-MON-RRRR')

ORDER BY org_name ASC