DBA Data[Home] [Help]

APPS.IEX_METRIC_PVT dependencies on GL_SETS_OF_BOOKS

Line 7: base_currency gl_sets_of_books.currency_code%TYPE ,

3: PG_DEBUG NUMBER;
4: --BEGIN-FIX BUG#4375831-05/18/2005-JYPARK-fix error ORA-06521 because x_metric_value_tbl has charater value so convert to numeric value
5: TYPE curr_rec_type IS RECORD (
6: set_of_books_id ar_system_parameters.set_of_books_id%TYPE ,
7: base_currency gl_sets_of_books.currency_code%TYPE ,
8: base_precision fnd_currencies.precision%type ,
9: base_min_acc_unit fnd_currencies.minimum_accountable_unit%type ,
10: past_year_from DATE,
11: past_year_to DATE

Line 550: --Replaced view gl_sets_of_books with gl_ledgers_public_v

546:
547: END Test_Metric;
548: BEGIN
549: --Strat MOAC
550: --Replaced view gl_sets_of_books with gl_ledgers_public_v
551: --Begin bug#5208170 schekuri 29-May-2006
552: --Removed this because it's not being used anywhere
553: /*SELECT gll.currency_code,
554: c.precision,

Line 572: gl_sets_of_books sob,

568: INTO g_curr_rec.base_currency,
569: g_curr_rec.base_precision,
570: g_curr_rec.base_min_acc_unit
571: FROM ar_system_parameters sysp,
572: gl_sets_of_books sob,
573: fnd_currencies c
574: WHERE sob.set_of_books_id = sysp.set_of_books_id
575: AND sob.currency_code = c.currency_code;*/
576: --End MOAC