($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