APPS.OKL_QA_DATA_INTEGRITY dependencies on OKL_LA_COV_ASSET_UV

Line 694: FROM okl_la_cov_asset_uv

690:
691: CURSOR srv_csr (p_serv_top_line_id NUMBER) IS
692: SELECT item_id inventory_item_id,
693: SUM(service_item_qty) quantity
694: FROM okl_la_cov_asset_uv
695: WHERE serv_top_line_id = p_serv_top_line_id
696: GROUP BY item_id;
697:
698: l_lne l_lne_csr%ROWTYPE;

Line 876: FROM okl_la_cov_asset_uv

872:
873: CURSOR srv_amt_csr (p_serv_top_line_id NUMBER) IS
874: SELECT item_id inventory_item_id,
875: SUM(NVL(price_negotiated,0)) amount
876: FROM okl_la_cov_asset_uv
877: WHERE serv_top_line_id = p_serv_top_line_id
878: GROUP BY item_id;
879:
880: l_lne l_toplne_csr%ROWTYPE;