问根据列值更改where条件

EN

     SELECT ptg.group_cid
     FROM PRVDR_TYPE_X_SPCLTY_SUBSPCLTY ptxss,
      PT_X_SP_SSP_STATUS pxsst ,
      pt_sp_ssp_x_group ptg,
      group_x_group_store gg,
      specialty_subspecialty sp_sbsp,
      treatment_type tt,
      provider_type pt
    WHERE 
    pt.PRVDR_TYPE_CODE          = ptxss.PRVDR_TYPE_CODE
    AND tt.TRTMNT_TYPE_CODE           = pxsst.TRTMNT_TYPE_CODE
    AND ptxss.PRVDR_TYPE_X_SPCLTY_SID = pxsst.PRVDR_TYPE_X_SPCLTY_SID
    AND tt.TRTMNT_TYPE_CODE           = p_pac_code
    AND TRUNC(SYSDATE) BETWEEN TRUNC(PXSST.FROM_DATE) AND TRUNC(PXSST.TO_DATE)
    AND ptg.prvdr_type_code        =ptxss.prvdr_type_code
    AND ptg.spclty_subspclty_sid   = ptxss.spclty_subspclty_sid
    AND ptxss.spclty_subspclty_sid = sp_sbsp.spclty_subspclty_sid
    AND ptg.spclty_subspclty_sid   = sp_sbsp.spclty_subspclty_sid
    AND ptg.status_cid             = 2
    AND ptg.group_cid              = gg.group_cid
    AND gg.group_store_cid         = 16
    AND gg.status_cid              = 2;