DBA Data[Home] [Help]

APPS.PAY_PAYMENT_XML_PKG dependencies on FND_CURRENCIES_TL

Line 770: fnd_currencies_tl fctl

766: --
767: select instr(l_deposit_amount,'.'), precision
768: into is_decimal, currency_precision
769: from fnd_currencies fc,
770: fnd_currencies_tl fctl
771: where fc.currency_code=g_currency_code
772: and fc.currency_code=fctl.currency_code
773: and fctl.language=userenv('lang');
774: --

Line 797: fnd_currencies_tl fctl

793: substr(l_deposit_amount,-1*precision,precision)
794: ,nvl(fctl.description,fc.currency_code)
795: into is_decimal,decimal_amount,currency_description
796: from fnd_currencies fc,
797: fnd_currencies_tl fctl
798: where fc.currency_code=g_currency_code
799: and fc.currency_code=fctl.currency_code
800: and fctl.language=userenv('lang');
801: l_amount_in_words := null;

Line 809: fnd_currencies_tl fctl

805: substr(l_deposit_amount,-1*precision,precision)
806: ,nvl(fctl.description,fc.currency_code)
807: into l_amount_in_words,is_decimal,decimal_amount,currency_description
808: from fnd_currencies fc ,
809: fnd_currencies_tl fctl
810: where fc.currency_code=g_currency_code
811: and fc.currency_code=fctl.currency_code
812: and fctl.language=userenv('lang');
813: end if;