APPS.PV_CONTEXT_VALUES dependencies on DUAL

Line 291: FOR x IN (SELECT user FROM dual) LOOP

287: -- g_apps_schema is introduced to handle Oracle 10g schema swapping.
288: -- See bug # 3871688. Reference to schema should not be hard-coded.
289: -- -----------------------------------------------------------------------
290: IF (g_apps_schema IS NULL) THEN
291: FOR x IN (SELECT user FROM dual) LOOP
292: g_apps_schema := x.user;
293: END LOOP;
294: END IF;
295:

Line 946: FOR x IN (SELECT user FROM dual) LOOP

942: -- -----------------------------------------------------------------------
943: -- Determine "APPS" schema.
944: -- -----------------------------------------------------------------------
945: IF (g_apps_schema IS NULL) THEN
946: FOR x IN (SELECT user FROM dual) LOOP
947: g_apps_schema := x.user;
948: END LOOP;
949: END IF;
950:

Line 3194: FROM dual;

3190: SELECT DISTINCT column_value
3191: FROM TABLE (CAST(l_output_tbl AS JTF_VARCHAR2_TABLE_4000)))
3192: AS JTF_VARCHAR2_TABLE_4000)
3193: INTO l_tmp_tbl
3194: FROM dual;
3195:
3196: l_output_tbl := l_tmp_tbl;
3197:
3198:

Line 3861: FOR x IN (SELECT user FROM dual) LOOP

3857: -- -----------------------------------------------------------------------
3858: -- Determine "APPS" schema.
3859: -- -----------------------------------------------------------------------
3860: IF (g_apps_schema IS NULL) THEN
3861: FOR x IN (SELECT user FROM dual) LOOP
3862: g_apps_schema := x.user;
3863: END LOOP;
3864: END IF;
3865: