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 561: fnd_currencies c

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;*/
564: --End bug#5208170 schekuri 29-May-2006
565: /*SELECT sob.currency_code,

Line 573: fnd_currencies c

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
577: