APPS.WSH_PICK_LIST dependencies on DUAL

Line 1256: select WSH_DELIVERY_GROUP_S.nextval into l_group_match_seq_tbl(i).delivery_group_id from dual;

1252:
1253: IF NOT l_match_found THEN
1254: --{
1255: l_group_match_seq_tbl(i).match_group_id :=l_attr_tab(i).group_id;
1256: select WSH_DELIVERY_GROUP_S.nextval into l_group_match_seq_tbl(i).delivery_group_id from dual;
1257: --}
1258: End IF;
1259:
1260: IF l_debug_on THEN

Line 3302: FROM dual

3298: 'PRINTER',
3299: batch_rec.organization_id,
3300: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).printer_name,
3301: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i).conc_program_name
3302: FROM dual
3303: WHERE NOT EXISTS (
3304: SELECT 'x'
3305: FROM wsh_pr_workers
3306: WHERE batch_id = WSH_PICK_LIST.G_BATCH_ID

Line 5357: select WSH_DELIVERY_GROUP_S.nextval into l_group_match_seq_tbl(i).delivery_group_id from dual;

5353:
5354: IF NOT l_match_found THEN
5355: --{
5356: l_group_match_seq_tbl(i).match_group_id :=l_attr_tab(i).group_id;
5357: select WSH_DELIVERY_GROUP_S.nextval into l_group_match_seq_tbl(i).delivery_group_id from dual;
5358: --}
5359: End IF;
5360:
5361: l_carton_grouping_tbl(l_carton_grouping_tbl.COUNT+1) := l_group_match_seq_tbl(i).delivery_group_id;