DBA Data[Home] [Help]

APPS.PN_INDEX_HISTORY_HEADERS_PKG dependencies on DUAL

Line 70: FROM DUAL;

66: -- If no INDEX_ID is provided, get one from sequence
67: IF (x_index_id IS NULL) THEN
68: SELECT pn_index_history_headers_s.NEXTVAL
69: INTO x_index_id
70: FROM DUAL;
71: END IF;
72:
73: check_unq_index_type (l_return_status, x_index_id, x_name);
74:

Line 322: FROM DUAL

318: l_dummy NUMBER;
319: BEGIN
320: SELECT 1
321: INTO l_dummy
322: FROM DUAL
323: WHERE NOT EXISTS ( SELECT 1
324: FROM pn_index_history_headers
325: WHERE (name = x_name)
326: AND ( (x_index_id IS NULL)