DBA Data[Home] [Help]

APPS.IBY_AMOUNT_IN_WORDS dependencies on DUAL

Line 351: from dual;

347: 1,p_unit_singular,
348: p_unit_plural)
349: ))
350: into l_currency_word
351: from dual;
352: else
353:
354: -- Added the package call ap_amount_utilities_pkg
355: -- which handles the word conversion for decimal digits

Line 430: from dual;

426: end if;
427:
428: select substr(userenv('LANGUAGE'),1,instr(userenv('LANGUAGE'),'_')-1)
429: into session_language
430: from dual;
431:
432: iby_debug_pub.add(debug_msg => 'numeral: ' || numeral,
433: debug_level => FND_LOG.LEVEL_STATEMENT,
434: module => l_Debug_Module);

Line 1215: FROM dual;

1211: null) ||
1212: decode(100*(abs(Chk_Amt)-trunc(abs(Chk_Amt))),
1213: 0,'pesos', 'pesos con ' || TO_CHAR(ABS(100*(abs(Chk_Amt)-trunc(abs(Chk_Amt))))) || ' Centavos ')
1214: INTO l_amt_spanish1
1215: FROM dual;
1216:
1217: return(l_amt_spanish1);
1218:
1219: END AMOUNT_WORDS_SPANISH;