DBA Data[Home] [Help]

APPS.OKL_RELEASE_PVT dependencies on FA_ADDITIONS

Line 2489: from fa_additions_b

2485:
2486: --cursor to fetch asset number
2487: cursor l_asset_num_csr(p_asset_id in number) is
2488: select asset_number
2489: from fa_additions_b
2490: where asset_id = p_Asset_id;
2491:
2492: l_asset_num_rec l_asset_num_csr%ROWTYPE;
2493:

Line 6630: FROM fa_additions fad,

6626: CURSOR fa_asset_csr(p_asset_number IN VARCHAR2)
6627: IS
6628: SELECT fab.asset_id,
6629: fab.book_type_code
6630: FROM fa_additions fad,
6631: fa_book_controls fbc,
6632: fa_books fab
6633: WHERE fad.asset_number = p_asset_number
6634: AND fab.asset_id = fad.asset_id