SQL Query to fetch the Project Billing Currency Type code in Oracle cloud fusion.

Here is the SQL Query to fetch the Project Billing Currency Type codes in Oracle cloud fusion.


SELECT 'Billing Currency Type Code' "SETUP_NAME",
               flvl.lookup_code  VALUE
  FROM   fnd_lookup_values_vl flvl
 WHERE lookup_type = 'PJB_BILLING_CURRENCY_TYPE'
     AND enabled_flag = 'Y'
    AND TRUNC(SYSDATE) BETWEEN NVL (start_date_active,TRUNC(SYSDATE) - 1) AND NVL (end_date_active, TRUNC(SYSDATE) + 1) ;