APPS.OKL_SPLIT_ASSET_PVT dependencies on OKX_ASSETS_V

Line 3434: FROM okx_assets_v okx

3430:
3431: --chk for asset in FA
3432: CURSOR asset_chk_curs1 (p_asset_number IN VARCHAR2) IS
3433: SELECT 'Y'
3434: FROM okx_assets_v okx
3435: WHERE okx.asset_number = p_asset_number;
3436:
3437: --chk for asset on asset line
3438: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS

Line 3522: FROM okx_assets_v okx

3518:
3519: --chk for asset in FA
3520: CURSOR asset_chk_curs1 (p_asset_number IN VARCHAR2) IS
3521: SELECT 'Y'
3522: FROM okx_assets_v okx
3523: WHERE okx.asset_number = p_asset_number;
3524:
3525: --chk for asset on asset line
3526: CURSOR asset_chk_curs2 (p_asset_number IN VARCHAR2) IS

Line 11133: FROM okx_assets_v ast,

11129: --cursor to fetch already created asset id if book_class is TAX ie. corp book is already created
11130: CURSOR get_ast_id_cur (p_asset_number IN VARCHAR2,
11131: p_book_type_code IN VARCHAR2) IS
11132: SELECT DECODE(bkc.book_class,'CORPORATE',NULL,'TAX',ast.asset_id)
11133: FROM okx_assets_v ast,
11134: okx_asst_bk_controls_v bkc
11135: WHERE ast.asset_number = p_asset_number
11136: AND ast.corporate_book = bkc.mass_copy_source_book
11137: AND bkc.book_type_code = p_book_type_code;