SQL Query to get the Contract Party Role setup details in Oracle cloud fusion Contracts

Here is the SQL Query to get the Contract Party Role Setup details in Oracle cloud fusion.

SELECT  'Party Role Code' "SETUP_NAME",
                 'PARTY_ROLE_CODE'  SETUP_NAME_CODE,
                 flvl.lookup_code  VALUE
  FROM fnd_lookup_values_vl flvl
 WHERE lookup_type = 'OKC_PARTY_ROLE'
      AND enabled_flag = 'Y'
     AND TRUNC (SYSDATE) BETWEEN NVL (start_date_active,TRUNC(SYSDATE) - 1) AND NVL (end_date_active, TRUNC(SYSDATE) + 1) ;