DBA Data[Home] [Help]

APPS.IEX_METRIC_PVT dependencies on FND_CURRENCIES

Line 8: base_precision fnd_currencies.precision%type ,

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
12: );

Line 9: base_min_acc_unit fnd_currencies.minimum_accountable_unit%type ,

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
12: );
13:

Line 79: fnd_currencies c

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;
82: --End bug#5208170 schekuri 29-May-2006
83: BEGIN

Line 560: fnd_currencies c

556: g_curr_rec.base_precision,
557: g_curr_rec.base_min_acc_unit
558: FROM ar_system_parameters sysp,
559: gl_ledgers_public_v gll,
560: fnd_currencies c
561: WHERE gll.ledger_id = sysp.set_of_books_id
562: AND gll.currency_code = c.currency_code;*/
563: --End bug#5208170 schekuri 29-May-2006
564: /*SELECT sob.currency_code,

Line 572: fnd_currencies c

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