DBA Data[Home] [Help]

APPS.JL_JLCOARCR_XMLP_PKG dependencies on DUAL

Line 330: DUAL;

326: ,P_SUB_UNIT_SINGULAR
327: ,P_SUB_UNIT_PLURAL)))
328: INTO L_WORD_AMOUNT2
329: FROM
330: DUAL;
331: END IF;
332: IF P_UNIT_RATIO in (0,1) OR P_UNIT_RATIO IS NULL THEN
333: SELECT
334: INITCAP(LOWER(L_WORD_AMOUNT || ' ' || DECODE(TRUNC(P_AMOUNT)

Line 340: DUAL;

336: ,P_UNIT_SINGULAR
337: ,P_UNIT_PLURAL)))
338: INTO L_CURRENCY_WORD
339: FROM
340: DUAL;
341: ELSE
342: SELECT
343: INITCAP(LOWER(L_WORD_AMOUNT || ' ' || DECODE(TRUNC(P_AMOUNT)
344: ,1

Line 349: DUAL;

345: ,P_UNIT_SINGULAR
346: ,P_UNIT_PLURAL) || ' ' || L_WORD_AMOUNT2))
347: INTO L_CURRENCY_WORD
348: FROM
349: DUAL;
350: END IF;
351: RETURN (L_CURRENCY_WORD);
352: END GET_WORD_VALUE;
353: FUNCTION PRECISION(CUR_CODE IN VARCHAR2) RETURN NUMBER IS