DBA Data[Home] [Help]

APPS.OKL_AM_TERMNT_QUOTE_PVT dependencies on FA_BOOKS

Line 474: FA_BOOKS fab

470: SELECT oal.asset_id asset_id,
471: oal.asset_number asset_number,
472: fab.book_type_code book_type_code
473: FROM OKX_ASSET_LINES_V oal,
474: FA_BOOKS fab
475: WHERE oal.parent_line_id = p_kle_id -- fin id
476: AND oal.asset_id = fab.asset_id
477: AND fab.date_ineffective IS NULL
478: AND fab.transaction_header_id_out IS NULL;

Line 519: -- loop thru all the FA books for the asset and for each book check the fa validations

515: END IF;
516:
517: l_return_status := OKL_API.G_RET_STS_SUCCESS;
518:
519: -- loop thru all the FA books for the asset and for each book check the fa validations
520: FOR get_fa_dtls_rec IN get_fa_dtls_csr (p_kle_id) LOOP
521:
522: -- call cache for book details
523: IF NOT fa_cache_pkg.fazcbc(X_book => get_fa_dtls_rec.book_type_code) THEN