APPS.FA_CUA_MASS_EXT_RET_PKG dependencies on GL_SETS_OF_BOOKS

Line 39: G_Currency_Code gl_sets_of_books.currency_code%TYPE;

35: G_Precision NUMBER;
36: G_Ext_Precision NUMBER;
37: G_Min_Acct_Unit NUMBER;
38: G_Today_Datetime DATE := SYSDATE;
39: G_Currency_Code gl_sets_of_books.currency_code%TYPE;
40: G_Set_of_Books_ID fa_book_controls.set_of_books_id%TYPE;
41: G_calc_gain_loss_flag varchar2(50) := FND_API.G_FALSE;
42: G_Distribution_id fa_distribution_history.distribution_id%TYPE;
43: -- bug 1857395

Line 196: gl_sets_of_books sob

192: FROM fa_mass_Ext_retirements mer,
193: fa_books bks,
194: fa_additions_b ad,
195: fa_book_controls fbc,
196: gl_sets_of_books sob
197: WHERE mer.review_status = 'POST'
198: AND mer.book_type_code = fbc.book_type_code
199: AND fbc.set_of_books_id = sob.set_of_books_id
200: AND mer.batch_name = nvl(px_batch_name,mer.batch_name)

Line 393: from gl_sets_of_books sob,

389:
390: Cursor c_currency_info IS
391: select
392: fc.precision
393: from gl_sets_of_books sob,
394: fa_book_controls fbc,
395: fnd_currencies fc
396: where fc.currency_code = sob.currency_code
397: and fc.enabled_flag = 'Y'