APPS.AHL_PRD_PRINT_PVT dependencies on DUAL

Line 70: dual;

66: CURSOR c_get_tz_offset(c_tz_code IN VARCHAR2)
67: IS
68: SELECT substr(tz_offset(c_tz_code),0,6)
69: FROM
70: dual;
71:
72: l_tz_offset VARCHAR2(100);
73: l_tz_code VARCHAR2(50);
74:

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

1212:
1213: --l_query_string := l_query_string || ' ORDER BY RESULTS.OCCURRENCE ';
1214:
1215: --add dummy query to the original query
1216: l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';
1217: x_query_string := l_query_string;
1218:
1219: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1220: fnd_log.string

Line 2650: SELECT c_ue_id FROM DUAL

2646: AND UE.UNIT_EFFECTIVITY_ID = c_ue_id;
2647:
2648:
2649: CURSOR get_child_ue (c_ue_id IN NUMBER) IS
2650: SELECT c_ue_id FROM DUAL
2651: union
2652: SELECT unit_effectivity_id
2653: FROM AHL_UNIT_EFFECTIVITIES_B UE,
2654: (

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

7620: END IF;
7621: l_query_string := l_query_string || ' order by 1 ';
7622:
7623: --add dummy query to the original query
7624: -- l_query_string := l_query_string || l_dummy_query || ' FROM DUAL CONNECT BY 1 = 1 and level <= 3';
7625: x_query_string := l_query_string;
7626:
7627: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
7628: fnd_log.string