APPS.INVPVHDR dependencies on DUAL

Line 656: INTO l_deliminator_count FROM DUAL;

652: l_deliminator_count := 0;
653: IF totalsegs > 1 THEN
654: WHILE l_deliminator_count < totalsegs -1 LOOP
655: SELECT INSTR(l_item_number,g_segment_delimiter,1,totalsegs -1)
656: INTO l_deliminator_count FROM DUAL;
657: IF l_deliminator_count < totalsegs -1 THEN
658: l_item_number := l_item_number ||g_segment_delimiter;
659: END IF;
660: END LOOP;

Line 2067: FROM DUAL;

2063: begin
2064:
2065: SELECT TO_CHAR(TO_NUMBER(cr.START_AUTO_LOT_NUMBER))
2066: INTO l_start_auto_lot_num
2067: FROM DUAL;
2068:
2069: exception
2070: when others then
2071: --Catch ORA-01722: invalid number and raise a error message.