APPS.WSH_CONTAINER_ACTIONS dependencies on DUAL

Line 707: FROM sys.dual;

703:
704: --added cursors
705: CURSOR Get_Wdd_Nextval IS
706: SELECT wsh_delivery_details_s.nextval
707: FROM sys.dual;
708:
709: CURSOR Get_Wda_Nextval IS
710: SELECT wsh_delivery_assignments_s.nextval
711: FROM sys.dual;

Line 711: FROM sys.dual;

707: FROM sys.dual;
708:
709: CURSOR Get_Wda_Nextval IS
710: SELECT wsh_delivery_assignments_s.nextval
711: FROM sys.dual;
712:
713: l_cont_instance_id NUMBER;
714: l_cont_name VARCHAR2(50);
715: l_description VARCHAR2(240);

Line 1327: SELECT 'NOT EMPTY' FROM DUAL

1323: p_container_id IN number,
1324: x_return_status OUT NOCOPY VARCHAR2) IS
1325:
1326: CURSOR Check_Hierarchy (v_detail_id NUMBER) IS
1327: SELECT 'NOT EMPTY' FROM DUAL
1328: WHERE EXISTS (
1329: SELECT delivery_detail_id
1330: FROM wsh_delivery_assignments
1331: WHERE parent_delivery_detail_id = v_detail_id

Line 12994: SELECT NVL(MAX(1),0) FROM DUAL

12990: x_cont_names OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type,
12991: x_return_status OUT NOCOPY VARCHAR2) IS
12992:
12993: CURSOR Get_Exist_Cont(v_cont_name VARCHAR2) IS
12994: SELECT NVL(MAX(1),0) FROM DUAL
12995: WHERE EXISTS ( SELECT 1 FROM WSH_DELIVERY_DETAILS
12996: WHERE container_name = v_cont_name
12997: AND container_flag = 'Y');
12998: