Oracle BI report query for getting approved, pending and draft Goals

Summary:

We are using the below sql query to get the status on the Goals submitted by employees. However, it is not fetching us the correct data. The report shows the "pending for approval" Goals as already approved Goals.

Please see the query below:

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Workforce Goals - Goal Status Overview Real Time"."Business Unit"."Business Unit Name" s_1,
"Workforce Goals - Goal Status Overview Real Time"."Department"."Department Name" s_2,
"Workforce Goals - Goal Status Overview Real Time"."Job"."Job Name" s_3,
"Workforce Goals - Goal Status Overview Real Time"."Legal Employer"."Name" s_4,