APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on GL_SETS_OF_BOOKS

Line 33: G_Currency_Code gl_sets_of_books.currency_code%TYPE;

29: G_Precision NUMBER;
30: G_Ext_Precision NUMBER;
31: G_Min_Acct_Unit NUMBER;
32: G_Today_Datetime DATE := SYSDATE;
33: G_Currency_Code gl_sets_of_books.currency_code%TYPE;
34: G_Set_of_Books_ID fa_book_controls.set_of_books_id%TYPE;
35: G_calc_gain_loss_flag varchar2(50) := FND_API.G_FALSE;
36: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
37: -- bug 1857395

Line 186: gl_sets_of_books sob

182: FROM fa_mass_Ext_retirements mer,
183: fa_books bks,
184: fa_additions_b ad,
185: fa_book_controls fbc,
186: gl_sets_of_books sob
187: WHERE mer.review_status = 'POST'
188: AND mer.book_type_code = fbc.book_type_code
189: AND fbc.set_of_books_id = sob.set_of_books_id
190: AND mer.batch_name = nvl(px_batch_name,mer.batch_name)

Line 377: from gl_sets_of_books sob,

373:
374: Cursor c_currency_info IS
375: select
376: fc.precision
377: from gl_sets_of_books sob,
378: fa_book_controls fbc,
379: fnd_currencies fc
380: where fc.currency_code = sob.currency_code
381: and fc.enabled_flag = 'Y'