DBA Data[Home] [Help]

APPS.OZF_TP_UTIL_QUERIES dependencies on DUAL

Line 291: NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99) from DUAL;

287: is
288: CURSOR org_cursor
289: IS
290: SELECT
291: NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99) from DUAL;
292:
293:
294: x_return_value varchar2(250);
295: l_org_id NUMBER;

Line 413: from dual;

409: BEGIN
410:
411: select inv_convert.inv_um_convert(p_object_id,null,p_qty,p_from_uom,p_to_uom,null,null)
412: into x_return_value
413: from dual;
414: RETURN (x_return_value);
415:
416: EXCEPTION
417: WHEN OTHERS THEN