APPS.WSH_DELIVERY_DETAILS_GRP dependencies on WMS_LICENSE_PLATE_NUMBERS_S2

Line 4971: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.nextval

4967: FROM mtl_parameters
4968: WHERE ORGANIZATION_ID = v_organization_id;
4969:
4970: CURSOR c_get_wms_next_seq IS
4971: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.nextval
4972: FROM DUAL;
4973: CURSOR c_get_wms_curr_seq IS
4974: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.currval
4975: FROM DUAL;

Line 4974: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.currval

4970: CURSOR c_get_wms_next_seq IS
4971: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.nextval
4972: FROM DUAL;
4973: CURSOR c_get_wms_curr_seq IS
4974: SELECT WMS_LICENSE_PLATE_NUMBERS_S2.currval
4975: FROM DUAL;
4976:
4977: l_lpn_starting_num NUMBER;
4978: l_wms_sequence NUMBER;