select a.*,decode(a.BRID00,0,'Y','N') FLAG00,decode(a.BRID00,0,'未对应','已对应') DYBZ00, 
nvl((select d.ECPDBZ from SF_HZBR00 d where d.YSPBID=a.GHHBID and d.HZXH00= a.YYH000),0) as ECPDBZ,
 (select SCKBH0 from BM_CKDY00 where DCKBH0=a.GHHZCK and rownum=1 ) FZCKBH   from vw_yy_bryyxxcx a where (a.BRID00=? or a.BRXM00=?) 
 and a.YYRQ00=to_char(sysdate, 'YYYYMMDD') and ((a.YYJSSJ>'12:00:00' and to_char(sysdate, 'HH24:MI:SS')>'12:00:00' ) or (a.YYJSSJ<='12:00:00' and to_char(sysdate, 'HH24:MI:SS')<='12:00:00' ) )
           and a.YYZT00 in ('0','1')