DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_FEE_PVT dependencies on OKL_ASSETS_B

Line 644: FROM okl_assets_b

640: IF l_link_asset_tbl.EXISTS(i) THEN
641:
642: SELECT NVL(OEC, 0)
643: INTO l_asset_oec
644: FROM okl_assets_b
645: WHERE id = l_link_asset_tbl(i).source_line_id;
646:
647: l_oec_total := l_oec_total + l_asset_oec;
648:

Line 672: FROM okl_assets_b

668: ELSE
669:
670: SELECT NVL(OEC, 0)
671: INTO l_asset_oec
672: FROM okl_assets_b
673: WHERE id = l_link_asset_tbl(i).source_line_id;
674:
675: IF l_link_asset_tbl.COUNT = 1 THEN
676:

Line 2327: FROM OKL_ASSETS_B

2323:
2324: CURSOR c_get_new_asset_id (p_source_asset_id IN NUMBER,
2325: p_target_quote_id In NUMBER) IS
2326: SELECT id
2327: FROM OKL_ASSETS_B
2328: WHERE ORIG_ASSET_ID = p_source_asset_id
2329: AND PARENT_OBJECT_ID = p_target_quote_id;
2330:
2331: BEGIN