APPS.WSH_DELIVERY_VALIDATIONS dependencies on DUAL

Line 388: SELECT 1 from dual

384: x_valid_flag OUT NOCOPY BOOLEAN,
385: x_return_status OUT NOCOPY VARCHAR2) IS
386:
387: CURSOR check_arrival_set IS
388: SELECT 1 from dual
389: WHERE exists (
390: SELECT 1
391: FROM wsh_delivery_details dd,
392: wsh_delivery_assignments_v da

Line 3068: from dual;

3064: IF l_line_inv_flag_rec.details_required_flag <> 'Y' THEN
3065:
3066: select DECODE(wsh_util_validate.Check_Wms_Org(l_line_inv_rec.organization_id),'Y','TRUE','FALSE')
3067: into l_wms_enabled
3068: from dual;
3069:
3070: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(
3071: p_source_line_id => l_line_inv_rec.source_line_id,
3072: p_source_code => l_line_inv_rec.source_code,