DBA Data[Home] [Help]

APPS.AHL_PRD_PRINT_PVT dependencies on DUAL

Line 42: dual;

38: CURSOR c_get_tz_offset(c_tz_code IN VARCHAR2)
39: IS
40: SELECT substr(tz_offset(c_tz_code),0,6)
41: FROM
42: dual;
43:
44: l_tz_offset VARCHAR2(100);
45: l_tz_code VARCHAR2(50);
46:

Line 1188: l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';

1184:
1185: --l_query_string := l_query_string || ' ORDER BY RESULTS.OCCURRENCE ';
1186:
1187: --add dummy query to the original query
1188: l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';
1189: x_query_string := l_query_string;
1190:
1191: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1192: fnd_log.string