APPS.INVPVHDR dependencies on DUAL

Line 647: INTO l_deliminator_count FROM DUAL;

643: l_deliminator_count := 0;
644: IF totalsegs > 1 THEN
645: WHILE l_deliminator_count < totalsegs -1 LOOP
646: SELECT INSTR(l_item_number,g_segment_delimiter,1,totalsegs -1)
647: INTO l_deliminator_count FROM DUAL;
648: IF l_deliminator_count < totalsegs -1 THEN
649: l_item_number := l_item_number ||g_segment_delimiter;
650: END IF;
651: END LOOP;

Line 2014: FROM DUAL;

2010: begin
2011:
2012: SELECT TO_CHAR(TO_NUMBER(cr.START_AUTO_LOT_NUMBER))
2013: INTO l_start_auto_lot_num
2014: FROM DUAL;
2015:
2016: exception
2017: when others then
2018: --Catch ORA-01722: invalid number and raise a error message.