APPS.IBY_AMOUNT_IN_WORDS dependencies on DUAL

Line 359: from dual;

355: l_log := my_log(10,p_unit_ratio);
356:
357: select substr(userenv('LANGUAGE'),1,instr(userenv('LANGUAGE'),'_')-1)
358: into session_language
359: from dual;
360:
361: if p_unit_ratio in (0,1) or p_unit_ratio is null or (p_amount-trunc(p_amount) = 0 and session_language = 'ARABIC') then
362: select initcap(lower(
363: l_word_amount||' '||

Line 369: from dual;

365: 1,p_unit_singular,
366: p_unit_plural)
367: ))
368: into l_currency_word
369: from dual;
370:
371: --bug 14005849
372: elsif(p_currency_code = 'AED') then
373: l_part_amount_word := apamtutb_ap_convert_number(lpad(to_char(trunc((p_amount-trunc(p_amount))*p_unit_ratio)),

Line 469: from dual;

465: end if;
466:
467: select substr(userenv('LANGUAGE'),1,instr(userenv('LANGUAGE'),'_')-1)
468: into session_language
469: from dual;
470:
471: iby_debug_pub.add(debug_msg => 'numeral: ' || numeral,
472: debug_level => FND_LOG.LEVEL_STATEMENT,
473: module => l_Debug_Module);

Line 1299: FROM dual;

1295: null) ||
1296: decode(100*(abs(Chk_Amt)-trunc(abs(Chk_Amt))),
1297: 0,'pesos', 'pesos con ' || TO_CHAR(ABS(100*(abs(Chk_Amt)-trunc(abs(Chk_Amt))))) || ' Centavos ')
1298: INTO l_amt_spanish1
1299: FROM dual;
1300:
1301: return(l_amt_spanish1);
1302:
1303: END AMOUNT_WORDS_SPANISH;