SQL Query to fetch the Project Contracts Billing Cycle setup details in Oracle cloud.

Here is the SQL Query to fetch the Project Contracts Billing Cycle setup details in Oracle cloud.

SELECT 'Billing Cycle' "SETUP_NAME",
            pbc.billing_cycle_name VALUE
  FROM  pjf_billing_cycles_vl pbc
 WHERE TRUNC(SYSDATE) BETWEEN NVL (start_date_active,TRUNC(SYSDATE) - 1) AND  NVL (end_date_active, TRUNC(SYSDATE) + 1);