APPS.WSH_CARRIERS_GRP dependencies on DUAL

Line 1627: SELECT lpad(to_char(l_maxnum),6,'0') into l_code1 from dual;

1623: FROM fnd_lookup_values_vl
1624: WHERE substr(lookup_code,7, length(lookup_code)) = substr(l_code,7,length(l_code))
1625: AND lookup_type = 'SHIP_METHOD';
1626:
1627: SELECT lpad(to_char(l_maxnum),6,'0') into l_code1 from dual;
1628:
1629: l_code := lpad(to_char(to_number(substr(l_code1,1,6))+1),6,'0')||substr(l_code,7,length(l_code));
1630:
1631: END IF;