Query to get Approval Group details in Approval Hierarchy - Oracle APPS

SELECT name operating_unit

  ,control_group_id

  ,control_group_name

  ,description

  ,creation_date

FROM po_control_groups_all pcga

    ,hr_operating_units hou

WHERE hou.organization_id = pcga.org_id

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

     'DD-MON-YYYY')

      AND TO_DATE ('28-OCT-2021',

     'DD-MON-YYYY')

ORDER BY creation_date DESC