DBA Data[Home] [Help]

APPS.AMS_QUERY_TEMPLATE_PKG dependencies on DUAL

Line 380: FROM DUAL;

376: WHERE TEMPLATE_ID = X_TEMPLATE_ID;
377:
378: CURSOR c_get_id is
379: SELECT AMS_QUERY_TEMPLATE_ALL_s.NEXTVAL
380: FROM DUAL;
381: BEGIN
382: if X_OWNER = 'SEED' then
383: l_user_id := 1;
384: elsif X_OWNER = 'ORACLE' then