[Home] [Help]
693: SELECT pov.OVE_ID, --required fk to okl_opt_values (okl_opv_rules_v.ove_id)
694: pov.ID,
695: pov.PON_ID,
696: pon.opt_id --product option id fk okl_pdt_opts
697: FROM OKL_PDT_OPT_VALS pov,
698: OKL_PDT_OPTS pon
699: WHERE pov.ID = p_pov_id --(p_pov id will be pov id fetched in last csr)
700: AND nvl(pov.FROM_DATE,sysdate) <= sysdate
701: AND nvl(pov.TO_DATE,sysdate+1) > sysdate