APPS.WSH_PICK_LIST dependencies on DUAL

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

1191:
1192: IF NOT l_match_found THEN
1193: --{
1194: l_group_match_seq_tbl(i).match_group_id :=l_attr_tab(i).group_id;
1195: select WSH_DELIVERY_GROUP_S.nextval into l_group_match_seq_tbl(i).delivery_group_id from dual;
1196: --}
1197: End IF;
1198:
1199: IF l_debug_on THEN

Line 3214: FROM dual

3210: WSH_PICK_LIST.G_BATCH_ID,
3211: 'PRINTER',
3212: batch_rec.organization_id,
3213: WSH_INV_INTEGRATION_GRP.G_PRINTERTAB(i)
3214: FROM dual
3215: WHERE NOT EXISTS (
3216: SELECT 'x'
3217: FROM wsh_pr_workers
3218: WHERE batch_id = WSH_PICK_LIST.G_BATCH_ID

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

5244:
5245: IF NOT l_match_found THEN
5246: --{
5247: l_group_match_seq_tbl(i).match_group_id :=l_attr_tab(i).group_id;
5248: select WSH_DELIVERY_GROUP_S.nextval into l_group_match_seq_tbl(i).delivery_group_id from dual;
5249: --}
5250: End IF;
5251:
5252: l_carton_grouping_tbl(l_carton_grouping_tbl.COUNT+1) := l_group_match_seq_tbl(i).delivery_group_id;