I am changig dynamically block block property based on menu. I am calling same form in different three menus.
But below one not working. I added below code in pre-query.

I quired JOC No. 7002114 for :PARAMETER.CRNT_STS = 'A' but it is showing first record 7002097. Not showing 7002114 .
Please do the needful.
--------------
IF :PARAMETER.CRNT_STS = 'S' THEN
SET_BLOCK_PROPERTY('B1',DEFAULT_WHERE,'WHERE GJM_JOC_CAT = ''O'' AND (GJM_CRNT_STS = ''U'' OR GJM_WRK_CPMLCTN_STS = ''U'') AND GJM_JOC_NO = NVL('||''''||*:B1.GJM_JOC_NO*||''''||',GJM_JOC_NO)');
END IF;

In your WHERE clause you test many different table columns, then we don't know what they contain, so that we cannot tell you what is wrong. Try to test you SQL order with Sql*Plus or Toad to see if the correct rows are fetched.