DBA Data[Home] [Help]

APPS.OKL_CPY_PDT_RULS_PVT dependencies on OKL_PDT_OPT_VALS

Line 697: FROM OKL_PDT_OPT_VALS pov,

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