DBA Data[Home] [Help]

APPS.CST_UTILITY_PUB dependencies on FND_CURRENCIES

Line 512: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

508:
509: /* local data variables */
510: l_sob_id number;
511: l_pri_curr gl_sets_of_books.currency_code%TYPE; -- varchar2(15);
512: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
513: l_precision fnd_currencies.precision%TYPE;
514: l_num number;
515:
516: l_api_message varchar2(150);

Line 513: l_precision fnd_currencies.precision%TYPE;

509: /* local data variables */
510: l_sob_id number;
511: l_pri_curr gl_sets_of_books.currency_code%TYPE; -- varchar2(15);
512: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
513: l_precision fnd_currencies.precision%TYPE;
514: l_num number;
515:
516: l_api_message varchar2(150);
517:

Line 635: from fnd_currencies

631: -- Get precision and minimum_accountable_unit for the primary currency
632: l_stmt_num := 90;
633: select precision, minimum_accountable_unit
634: into l_precision, l_min_acct_unit
635: from fnd_currencies
636: where currency_code = l_pri_curr;
637:
638: if (l_debug = 'Y') then
639: l_api_message := 'Got currency code = '||l_pri_curr;

Line 727: from mtl_material_transactions mmt, fnd_currencies fc

723: P_USER_ID,
724: sysdate,
725: P_USER_ID,
726: P_LOGIN_ID
727: from mtl_material_transactions mmt, fnd_currencies fc
728: where mmt.transaction_id = P_TXN_ID
729: and (mmt.organization_id = P_ORG_ID or
730: mmt.transfer_organization_id = P_ORG_ID)
731: and fc.currency_code = nvl(mmt.currency_code, l_pri_curr);