($P{SELECTED_EFFECTIVE_DATE}.equal("true")
    AND  $P{SELECTED_THROUGH_DATE}.equal("true")) ?
    SELECT PRD.PRD_IND AS PRODUCT_NM,PRD.PRD_DS AS PRODUCT_DESC,OFR.OFFR_DESC
    AS  OFFR_DESC,
    PRH.PRC_STA_DT AS START_DATE,PRH.PRC_END_DT AS END_DATE,SEU.SELL_UNIT_ID
    AS SELL_UNIT_ID,SEU.SELL_UNIT_NAME
    FROM $P!{EPISYS_SCHEMA}EPS_PRICE_HDR PRH
    INNER JOIN $P!{SCHEMA}EPS_EV_HDR EV ON EV.EPS_UID = PRH.EV_UID
    INNER JOIN $P!{SCHEMA}EPS_PRD_HDR PRD ON PRD.PRD_TYP_CD = PRH.PRD_TYP_CD
    AND PRD.PRD_CD = PRH.PRD_CD
    INNER JOIN $P!{SCHEMA}EPS_OFFR_HDR OFR ON OFR.EPS_UID = PRH.PRC_OFFR_ID
    INNER JOIN $P!{SCHEMA}EPS_SELL_UNIT SEU ON SEU.SELL_UNIT_ID = PRH.STR_GRP_ID
    WHERE EV.EV_TYP_CD = 'P'
    AND PRD.PRD_TYP_CD='SKU'
    AND PRH.ACTION != 'D'
    AND SEU.SELL_UNIT_ID= $P{SELL_UNIT_ID_STRING}
    AND (PRH.PRC_STA_DT BETWEEN TO_DATE($P{SELECTED_EFFECTIVE_DATE},'yyyy/mm/dd')
    AND TO_DATE($P{SELECTED_THROUGH_DATE},'yyyy/mm/dd'))
    OR(PRH.PRC_END_DT BETWEEN TO_DATE($P{SELECTED_EFFECTIVE_DATE},'yyyy/mm/dd')
    AND TO_DATE($P{SELECTED_THROUGH_DATE},'yyyy/mm/dd'))
    OR (PRH.PRC_STA_DT < TO_DATE($P{SELECTED_EFFECTIVE_DATE},'yyyy/mm/dd')
    AND TO_DATE($P{SELECTED_THROUGH_DATE},'yyyy/mm/dd') < PRH.PRC_END_DT)
    ORDER BY PRH.PRC_STA_DT,PRD.PRD_DS