DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on GL_SETS_OF_BOOKS

Line 3015: FROM gl_sets_of_books glsob,

3011: end if;
3012:
3013: -- Validate warranty currency is correct
3014: SELECT count(w.warranty_id) INTO l_count
3015: FROM gl_sets_of_books glsob,
3016: fa_book_controls bc,
3017: fa_warranties w
3018: WHERE w.warranty_id = p_warranty_id
3019: AND bc.book_type_code = p_book_type_code

Line 3048: from gl_sets_of_books sob,

3044: where category_id = p_category_id;
3045:
3046: CURSOR C1 IS
3047: select currency_code
3048: from gl_sets_of_books sob,
3049: fa_book_controls bc,
3050: fa_books bk
3051: where bk.asset_id = p_asset_id
3052: and bk.date_ineffective is null

Line 5273: from gl_sets_of_books sob

5269: add_err1 exception;
5270:
5271: CURSOR c_get_currency_code IS
5272: select currency_code
5273: from gl_sets_of_books sob
5274: where sob.set_of_books_id = p_asset_hdr_rec.set_of_books_id;
5275: l_currency_code varchar2(15) := '';
5276:
5277: BEGIN