Create dependent parameter based on date parameter

Value Set = CUST_BG_NO

Validation Table Information

Table Name : xxxx_x.bg_master m

Table COlumn :

Value ==m. bg_no

ID == m.bg_id

where

m.bg_doc_type = 'M'

AND 1 = case when APPS.FND_PROFILE.VALUE('ORG_ID') in (81,82) and m.org_id in(81,82) then 1 when APPS.FND_PROFILE.VALUE('ORG_ID') not in (81,82) and m.org_id = APPS.FND_PROFILE.VALUE('ORG_ID') then 1 end and m.dealer_account_no = :$FLEX$.cust_cc_numbers_all and m.date_to between nvl(to_date(:$FLEX$.FND_STANDARD_DATE, 'RRRR/MM/DD HH24:MI:SS'), m.date_to) 

and nvl(to_date(:$FLEX$.FND_STANDARD_DATE, 'RRRR/MM/DD HH24:MI:SS'), m.date_to)