APPS.WSH_DELIVERY_VALIDATIONS dependencies on DUAL

Line 393: SELECT 1 from dual

389: x_valid_flag OUT NOCOPY BOOLEAN,
390: x_return_status OUT NOCOPY VARCHAR2) IS
391:
392: CURSOR check_arrival_set IS
393: SELECT 1 from dual
394: WHERE exists (
395: SELECT 1
396: FROM wsh_delivery_details dd,
397: wsh_delivery_assignments_v da

Line 3126: from dual;

3122: IF l_line_inv_flag_rec.details_required_flag <> 'Y' AND l_line_inv_rec.inventory_item_id is not null THEN
3123:
3124: select DECODE(wsh_util_validate.Check_Wms_Org(l_line_inv_rec.organization_id),'Y','TRUE','FALSE')
3125: into l_wms_enabled
3126: from dual;
3127:
3128: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(
3129: p_source_line_id => l_line_inv_rec.source_line_id,
3130: p_source_code => l_line_inv_rec.source_code,