APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on DUAL

Line 1335: ' FROM DUAL';

1331: ':2, ' || -- p_entity_type
1332: ':3, ' || -- p_component_value
1333: ':4, ' || -- p_from_time
1334: ':5)' || -- p_to_time
1335: ' FROM DUAL';
1336: --Dbms_Output.put_line(' v_stmt ' || v_stmt);
1337: v_num_elements := Trunc((p_to_time - p_from_time) * 24) + 1;
1338: WHILE (v_from_time <= v_end_from_time AND v_continue) LOOP
1339: v_to_time := v_from_time + 1/24 - 1/86400;

Line 1659: v_stmt := v_stmt || ' FROM DUAL)';

1655: END IF;
1656: v_stmt := v_stmt || ':' || i || ' AS ID#' ||
1657: p_components(i).component_pk_key;
1658: END LOOP;
1659: v_stmt := v_stmt || ' FROM DUAL)';
1660:
1661: c := DBMS_SQL.OPEN_CURSOR;
1662: DBMS_SQL.PARSE(c, v_stmt, DBMS_SQL.NATIVE);
1663:

Line 1807: FROM DUAL;

1803: FOR reading_rec in cur_meter LOOP
1804: --SELECT round ((reading_rec.to_time - reading_rec.from_time) *24)
1805: SELECT (Trunc(reading_rec.to_time, 'hh24') - Trunc(reading_rec.from_time, 'hh24')) *24
1806: INTO l_hour_count
1807: FROM DUAL;
1808:
1809: FOR idx in 0..l_hour_count LOOP
1810: p_reading.EXTEND(1);
1811: BEGIN

Line 2235: FROM dual;

2231: -- Fill the esa_pk_key
2232: FOR i IN p_shift.FIRST..p_shift.LAST LOOP
2233: SELECT MTH_ENTITY_SUSTAIN_ASPECT_S.NEXTVAL
2234: INTO p_shift(i).esa_pk_key
2235: FROM dual;
2236: END LOOP;
2237:
2238:
2239: FOR i IN p_shift.FIRST..p_shift.LAST LOOP