DBA Data[Home] [Help]

APPS.IEX_CURRENCY_PVT dependencies on AR_SYSTEM_PARAMETERS

Line 1202: FROM ar_system_parameters sp,

1198: SELECT gll.currency_code,
1199: gll.ledger_id
1200: INTO g_functional_currency,
1201: g_set_of_books_id
1202: FROM ar_system_parameters sp,
1203: gl_ledgers_public_v gll
1204: WHERE gll.ledger_id = sp.set_of_books_id;
1205:
1206: x_functional_currency := g_functional_currency;

Line 1359: FROM ar_system_parameters sp,

1355: cnt_currency Number;
1356: BEGIN
1357: SELECT count(distinct gll.currency_code)
1358: INTO cnt_currency
1359: FROM ar_system_parameters sp,
1360: gl_ledgers_public_v gll
1361: WHERE gll.ledger_id = sp.set_of_books_id;
1362: Return (cnt_currency);
1363: EXCEPTION WHEN OTHERS THEN

Line 1381: -- FROM ar_system_parameters sp,

1377: -- SELECT sob.currency_code,
1378: -- sob.set_of_books_id
1379: -- INTO g_functional_currency,
1380: -- g_set_of_books_id
1381: -- FROM ar_system_parameters sp,
1382: -- gl_sets_of_books sob
1383: -- WHERE sob.set_of_books_id = sp.set_of_books_id;
1384: -- EXCEPTION
1385: -- WHEN OTHERS THEN