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 938: FOR x IN (SELECT user FROM dual) LOOP

934: -- -----------------------------------------------------------------------
935: -- Determine "APPS" schema.
936: -- -----------------------------------------------------------------------
937: IF (g_apps_schema IS NULL) THEN
938: FOR x IN (SELECT user FROM dual) LOOP
939: g_apps_schema := x.user;
940: END LOOP;
941: END IF;
942:

Line 3172: FROM dual;

3168: SELECT DISTINCT column_value
3169: FROM TABLE (CAST(l_output_tbl AS JTF_VARCHAR2_TABLE_4000)))
3170: AS JTF_VARCHAR2_TABLE_4000)
3171: INTO l_tmp_tbl
3172: FROM dual;
3173:
3174: l_output_tbl := l_tmp_tbl;
3175:
3176:

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

3835: -- -----------------------------------------------------------------------
3836: -- Determine "APPS" schema.
3837: -- -----------------------------------------------------------------------
3838: IF (g_apps_schema IS NULL) THEN
3839: FOR x IN (SELECT user FROM dual) LOOP
3840: g_apps_schema := x.user;
3841: END LOOP;
3842: END IF;
3843: