DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_SERVICE_PVT dependencies on OKL_ASSETS_B

Line 333: FROM okl_assets_b

329: IF l_link_asset_tbl.EXISTS(i) THEN
330:
331: SELECT NVL(OEC, 0)
332: INTO l_asset_oec
333: FROM okl_assets_b
334: WHERE id = l_link_asset_tbl(i).source_line_id;
335:
336: l_oec_total := l_oec_total + l_asset_oec;
337:

Line 361: FROM okl_assets_b

357: ELSE
358:
359: SELECT NVL(OEC, 0)
360: INTO l_asset_oec
361: FROM okl_assets_b
362: WHERE id = l_link_asset_tbl(i).source_line_id;
363:
364: IF l_link_asset_tbl.COUNT = 1 THEN
365:

Line 862: FROM OKL_ASSETS_B

858: lx_lrship_tbl lr_tbl_type;
859:
860: CURSOR c_get_new_asset_id (p_source_asset_id IN NUMBER) IS
861: SELECT id
862: FROM OKL_ASSETS_B
863: WHERE ORIG_ASSET_ID = p_source_asset_id;
864:
865: BEGIN
866: -- Get line relationships table