APPS.WSH_MDC_SRS dependencies on DUAL

Line 842: SELECT WSH_DELIVERY_GROUP_S.nextval INTO l_group_tab(l_group_index).group_id FROM DUAL;

838: ELSE
839: --{
840: l_group_tab(l_group_index).hash_value := l_delivery_addnl_attr_tab(i).hash_value;
841: l_group_tab(l_group_index).hash_string := l_delivery_addnl_attr_tab(i).hash_string;
842: SELECT WSH_DELIVERY_GROUP_S.nextval INTO l_group_tab(l_group_index).group_id FROM DUAL;
843: l_delivery_addnl_attr_tab(i).group_id := l_group_tab(l_group_index).group_id;
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.logmsg(l_module_name, 'Delivery '||l_delivery_addnl_attr_tab(i).delivery_id||' added to new hash group '||l_group_tab(l_group_index).group_id);
846: END IF;

Line 1407: SELECT INSTR(p_sel_del_attr.delivery_name_from,'%') INTO l_wc_index FROM DUAL;

1403: WSH_UTIL_CORE.PrintMsg(' Delivery name to: '||p_sel_del_attr.delivery_name_to);
1404:
1405: IF p_sel_del_attr.delivery_name_from = p_sel_del_attr.delivery_name_to
1406: THEN
1407: SELECT INSTR(p_sel_del_attr.delivery_name_from,'%') INTO l_wc_index FROM DUAL;
1408: IF l_wc_index = 0
1409: THEN
1410: l_where_clause := l_where_clause || ' AND WND.NAME = :p_del_name';
1411: l_col_tab(l_col_count) := p_sel_del_attr.delivery_name_from;