APPS.INV_LOT_SEL_ATTR dependencies on DUAL

Line 1151: FROM dual;

1147: IF(l_segments.default_type(j) = 'D') THEN
1148: /* Get the Value of the Current Date */
1149: SELECT SYSDATE
1150: INTO l_date
1151: FROM dual;
1152: ELSIF(l_segments.default_type(j) = 'C') THEN
1153: /* Constant Value is default */
1154: --l_date := to_date(l_segments.default_value(j),L_default_format);
1155: l_date := fnd_date.canonical_to_date(l_segments.default_value(j));

Line 1318: SELECT round(x_lot_serial_attributes(x).column_value, l_precision) INTO x_lot_serial_attributes(x).column_value FROM DUAL;

1314: IF (l_debug=1) THEN
1315: debug('PRECISION = ' || l_precision, l_module_name, l_debug_level);
1316: END IF;
1317: IF (l_precision >0) THEN
1318: SELECT round(x_lot_serial_attributes(x).column_value, l_precision) INTO x_lot_serial_attributes(x).column_value FROM DUAL;
1319: END IF;
1320: IF (l_debug=1) THEN
1321: debug('column_value1 = ' || x_lot_serial_attributes(x).column_value, l_module_name, l_debug_level);
1322: END IF;