APPS.JG_JGZZRCAK_XMLP_PKG dependencies on DUAL

Line 44: DUAL;

40: TO_CHAR(SYSDATE
41: ,'DD-MON-YYYY HH24:MI:SS')
42: INTO CP_SYSDATE
43: FROM
44: DUAL;
45: CP_LETTER_DATE := SUBSTR(CP_SYSDATE
46: ,1
47: ,11);
48: ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID;

Line 634: DUAL;

630: ,P_SUB_UNIT_SINGULAR
631: ,P_SUB_UNIT_PLURAL)))
632: INTO L_WORD_AMOUNT2
633: FROM
634: DUAL;
635: END IF;
636: IF P_UNIT_RATIO in (0,1) OR P_UNIT_RATIO IS NULL THEN
637: SELECT
638: INITCAP(LOWER(L_WORD_AMOUNT || ' ' || DECODE(TRUNC(P_AMOUNT)

Line 644: DUAL;

640: ,P_UNIT_SINGULAR
641: ,P_UNIT_PLURAL)))
642: INTO L_CURRENCY_WORD
643: FROM
644: DUAL;
645: ELSE
646: SELECT
647: INITCAP(LOWER(L_WORD_AMOUNT || ' ' || DECODE(TRUNC(P_AMOUNT)
648: ,1

Line 653: DUAL;

649: ,P_UNIT_SINGULAR
650: ,P_UNIT_PLURAL) || ' ' || L_WORD_AMOUNT2))
651: INTO L_CURRENCY_WORD
652: FROM
653: DUAL;
654: END IF;
655: RETURN (L_CURRENCY_WORD);
656: END GET_WORD_VALUE;
657: