DBA Data[Home] [Help]

APPS.AMS_QUERY_TEMP_INST_PKG dependencies on DUAL

Line 175: FROM DUAL;

171: WHERE TEMPLATE_INSTANCE_ID = x_TEMPLATE_INSTANCE_ID;
172:
173: CURSOR c_get_id is
174: SELECT AMS_QUERY_TEMPLATE_INSTANCE_s.NEXTVAL
175: FROM DUAL;
176: BEGIN
177: if X_OWNER = 'SEED' then
178: l_user_id := 1;
179: elsif X_OWNER = 'ORACLE' then