DBA Data[Home] [Help]

APPS.OKL_CONTRACT_STATUS_PVT dependencies on OKL_PRODUCTS_V

Line 248: FROM okl_products_v pdt

244: CURSOR Product_csr (p_contract_id IN NUMBER ) IS
245: SELECT pdt.id product_id
246: ,pdt.name product_name
247: ,chr.sts_code okl_status
248: FROM okl_products_v pdt
249: ,okl_k_headers khr
250: ,okc_k_headers_b chr
251: WHERE 1=1
252: AND khr.id = p_contract_id