APPS.OKL_SPLIT_ASSET_PVT dependencies on OKX_ASSETS_V

Line 3406: FROM okx_assets_v okx

3402:
3403: --chk for asset in FA
3404: CURSOR asset_chk_curs1 (p_asset_number IN VARCHAR2) IS
3405: SELECT 'Y'
3406: FROM okx_assets_v okx
3407: WHERE okx.asset_number = p_asset_number;
3408:
3409: --chk for asset on asset line
3410: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS

Line 3494: FROM okx_assets_v okx

3490:
3491: --chk for asset in FA
3492: CURSOR asset_chk_curs1 (p_asset_number IN VARCHAR2) IS
3493: SELECT 'Y'
3494: FROM okx_assets_v okx
3495: WHERE okx.asset_number = p_asset_number;
3496:
3497: --chk for asset on asset line
3498: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS

Line 11080: FROM okx_assets_v ast,

11076: --cursor to fetch already created asset id if book_class is TAX ie. corp book is already created
11077: CURSOR get_ast_id_cur (p_asset_number IN VARCHAR2,
11078: p_book_type_code IN VARCHAR2) IS
11079: SELECT DECODE(bkc.book_class,'CORPORATE',NULL,'TAX',ast.asset_id)
11080: FROM okx_assets_v ast,
11081: okx_asst_bk_controls_v bkc
11082: WHERE ast.asset_number = p_asset_number
11083: AND ast.corporate_book = bkc.mass_copy_source_book
11084: AND bkc.book_type_code = p_book_type_code;