IF :DEPT<>'ALL' OR :DEPT IS NULL THEN
 WHERE_STRING:='( CREATED_BY ='''||:GLOBAL.USER_ID||''' 
 OR ASSIGNED_TO = '''||:GLOBAL.USER_ID||''' 
 OR HR_GET_DEPT_SUPERVISOR(DEPT_CODE) = ''||:GLOBAL.USER_ID||''' 
 OR (C_TRANS_ID IN (SELECT C_TRANS_ID FROM ADMIN_COMPLAINTS_USERS WHERE USER_ID ='''||:GLOBAL.USER_ID||''') 
 AND C_TRANS_NO IN (SELECT C_TRANS_NO FROM  ADMIN_COMPLAINTS_USERS WHERE USER_ID = '''||:GLOBAL.USER_ID||'''))) 
AND STATUS='''||:COMPLAINT_STATUS||''' AND DEPT_CODE='''||:DEPT||'''';
SET_BLOCK_PROPERTY('ADMIN_COMPLAINTS_MAST',DEFAULT_WHERE,WHERE_STRING);

 GO_BLOCK('ADMIN_COMPLAINTS_MAST');
 DO_KEY('EXECUTE_QUERY');
ELSE
 WHERE_STRING:='( CREATED_BY ='''||:GLOBAL.USER_ID||''' 
 OR  ASSIGNED_TO = '''||:GLOBAL.USER_ID||''' 
 OR HR_GET_DEPT_SUPERVISOR(DEPT_CODE) = ''||:GLOBAL.USER_ID||''' 
 OR (C_TRANS_ID IN (SELECT C_TRANS_ID FROM  ADMIN_COMPLAINTS_USERS WHERE USER_ID ='''||:GLOBAL.USER_ID||''') 
AND C_TRANS_NO IN (SELECT C_TRANS_NO FROM ADMIN_COMPLAINTS_USERS WHERE USER_ID = '''||:GLOBAL.USER_ID||'''))) 
										 AND STATUS='''||:COMPLAINT_STATUS||'''';
SET_BLOCK_PROPERTY('ADMIN_COMPLAINTS_MAST',DEFAULT_WHERE,WHERE_STRING);
			
 GO_BLOCK('ADMIN_COMPLAINTS_MAST');
 DO_KEY('EXECUTE_QUERY');
END IF;