APPS.IEX_METRIC_PVT dependencies on AR_SYSTEM_PARAMETERS

Line 6: set_of_books_id ar_system_parameters.set_of_books_id%TYPE ,

2: /* $Header: iexvmtrb.pls 120.9.12010000.3 2010/04/30 04:03:28 nkanchan ship $ */
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,

Line 77: FROM ar_system_parameters sp,

73: c.precision,
74: c.minimum_accountable_unit,
75: TRUNC(add_months(sysdate, - 12)) pastYearFrom ,
76: TRUNC(sysdate) pastYearTo
77: FROM ar_system_parameters sp,
78: gl_ledgers_public_v gll,
79: fnd_currencies c
80: WHERE gll.ledger_id = sp.set_of_books_id
81: AND gll.currency_code = c.currency_code;

Line 559: FROM ar_system_parameters sysp,

555: c.minimum_accountable_unit
556: INTO g_curr_rec.base_currency,
557: g_curr_rec.base_precision,
558: g_curr_rec.base_min_acc_unit
559: FROM ar_system_parameters sysp,
560: gl_ledgers_public_v gll,
561: fnd_currencies c
562: WHERE gll.ledger_id = sysp.set_of_books_id
563: AND gll.currency_code = c.currency_code;*/

Line 571: FROM ar_system_parameters sysp,

567: c.minimum_accountable_unit
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;*/