DBA Data[Home] [Help]

APPS.GMI_ICR03_XMLP_PKG dependencies on DUAL

Line 738: DUAL;

734: SELECT
735: DOC_TYPE
736: INTO DOC_TYPE1
737: FROM
738: DUAL;
739: IF SQL%NOTFOUND THEN
740: RETURN (NULL);
741: ELSE
742: RETURN (DOC_TYPE1);

Line 762: DUAL;

758: ,'Warehouse Range: ' || FROM_WHSE || ' - All '
759: ,' Warehouse Range: ' || FROM_WHSE || ' - ' || TO_WHSE))
760: INTO RANGEV
761: FROM
762: DUAL;
763: RETURN (RANGEV);
764: END RANGE1CFFORMULA;
765: FUNCTION RANGE2CFFORMULA RETURN VARCHAR2 IS
766: BEGIN

Line 814: DUAL;

810: SELECT
811: UNIT_COSTCF * COUNT_QTYSC
812: INTO COSTACCUM
813: FROM
814: DUAL;
815: RETURN (COSTACCUM);
816: RETURN NULL;
817: EXCEPTION
818: WHEN OTHERS THEN