DBA Data[Home] [Help]

APPS.OKL_SUC_PVT dependencies on OKL_PRODUCT_PARAMETERS_V

Line 669: from okl_product_parameters_v pdt

665: x_return_status OUT NOCOPY VARCHAR2,
666: p_product_id IN NUMBER) IS
667: Cursor pdt_csr(p_product_id in number) is
668: Select 'Y'
669: from okl_product_parameters_v pdt
670: where id = p_product_id
671: and sysdate between nvl(pdt.from_date,sysdate) and nvl(pdt.to_date,sysdate);
672:
673: l_exists varchar2(1) default 'N';