DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on FA_ADDITIONS

Line 2513: from fa_additions_b

2509:
2510: --cursor to fetch asset number
2511: cursor l_asset_num_csr(p_asset_id in number) is
2512: select asset_number
2513: from fa_additions_b
2514: where asset_id = p_Asset_id;
2515:
2516: l_asset_num_rec l_asset_num_csr%ROWTYPE;
2517:

Line 6939: FROM fa_additions fad,

6935: CURSOR fa_asset_csr(p_asset_number IN VARCHAR2)
6936: IS
6937: SELECT fab.asset_id,
6938: fab.book_type_code
6939: FROM fa_additions fad,
6940: fa_book_controls fbc,
6941: fa_books fab
6942: WHERE fad.asset_number = p_asset_number
6943: AND fab.asset_id = fad.asset_id