The filter conditions on the column do not work

Summary

The filter conditions on the column do not work

Content

Dir sir/madam,

I'm doing an analysis,this is the compete SQL query which I want to create from OTBI:

    select "- Hierarchy"."Level 1 Department",

    (SELECT COUNT(1)

    FROM "Workforce Management - Worker Assignment Event Real Time" A

    WHERE "Assignment Event Details"."Effective Start Date" <=

    :START_DATE

    AND "Assignment Event Details"."Effective End Date" >=

    :START_DATE

    AND A.PRIMARY_FLAG = 'Y'

    AND A.ACTIVE_STATUS = 'ACTIVE'),

    (SELECT COUNT(1)

    FROM "Workforce Management - Worker Assignment Event Real Time" A

    WHERE "Assignment Event Details"."Effective Start Date" between

    :START_DATE and :END_DATE