DBA Data[Home] [Help]

APPS.AMS_LIST_QUERIES_NEW_PKG dependencies on DUAL

Line 411: FROM DUAL;

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