DBA Data[Home] [Help]

APPS.AMS_LIST_QUERIES_NEW_PKG dependencies on DUAL

Line 409: FROM DUAL;

405: WHERE LIST_QUERY_ID = X_LIST_QUERY_ID;
406:
407: CURSOR c_get_id is
408: SELECT AMS_LIST_QUERIES_ALL_S.NEXTVAL
409: FROM DUAL;
410: BEGIN
411: if X_OWNER = 'SEED' then
412: l_user_id := 1;
413: elsif X_OWNER = 'ORACLE' then