DBA Data[Home] [Help]

APPS.AMS_QUERY_PURP_ASSOC_PKG dependencies on DUAL

Line 144: FROM DUAL;

140: WHERE TEMP_PURPOSE_ASSOC_ID = x_TEMP_PURPOSE_ASSOC_ID;
141:
142: CURSOR c_get_id is
143: SELECT AMS_QUERY_TEMP_PURPOSE_ASSOC_s.NEXTVAL
144: FROM DUAL;
145: BEGIN
146: if X_OWNER = 'SEED' then
147: l_user_id := 1;
148: elsif X_OWNER = 'ORACLE' then