APPS.ICX_ON_UTILITIES dependencies on DUAL

Line 1559: from sys.dual;

1555: end if;
1556:
1557: select ICX_CONTEXT_RESULTS_TEMP_S.nextval
1558: into l_query_id
1559: from sys.dual;
1560:
1561: /* -- replace with intermedia !!!
1562: ctx_query.contains
1563: (POLICY_NAME => c_column_name,

Line 2099: --from sys.dual;

2095: -- changed to be more flexible and to work better in stateful envs.
2096:
2097: --select to_char(to_date(p_date))
2098: --into l_dummy_varchar2
2099: --from sys.dual;
2100: l_dummy_db_date:=icx_sec.getNLS_PARAMETER('NLS_DATE_FORMAT');
2101:
2102: IF (nvl(icx_sec.g_date_format,'X') <> nvl(icx_sec.g_date_format_c,'Y')) or
2103: (nvl(icx_sec.g_date_format_c,'Y') <> l_dummy_db_date) THEN

Line 2113: from sys.dual;

2109: END IF;
2110:
2111: select to_date(p_date,icx_sec.g_date_format)
2112: into l_dummy_date
2113: from sys.dual;
2114: -- end changes for 1618876
2115:
2116: if p_date <> l_dummy_varchar2
2117: then

Line 2120: from sys.dual;

2116: if p_date <> l_dummy_varchar2
2117: then
2118: select to_date(p_date,'XX-XXX-XXXX')
2119: into l_dummy_date
2120: from sys.dual;
2121: end if;
2122:
2123: end;
2124: