DBA Data[Home] [Help]

APPS.AMS_LIST_QUERIES_PARAM_PKG dependencies on DUAL

Line 414: FROM DUAL;

410: WHERE LIST_QUERY_PARAM_ID = X_LIST_QUERY_PARAM_ID;
411:
412: CURSOR c_get_id is
413: SELECT AMS_LIST_QUERIES_PARAM_S.NEXTVAL
414: FROM DUAL;
415: BEGIN
416: if X_OWNER = 'SEED' then
417: l_user_id := 1;
418: elsif X_OWNER = 'ORACLE' then