APPS.WSH_CONTAINER_ACTIONS dependencies on DUAL

Line 734: FROM sys.dual;

730:
731: --added cursors
732: CURSOR Get_Wdd_Nextval IS
733: SELECT wsh_delivery_details_s.nextval
734: FROM sys.dual;
735:
736: CURSOR Get_Wda_Nextval IS
737: SELECT wsh_delivery_assignments_s.nextval
738: FROM sys.dual;

Line 738: FROM sys.dual;

734: FROM sys.dual;
735:
736: CURSOR Get_Wda_Nextval IS
737: SELECT wsh_delivery_assignments_s.nextval
738: FROM sys.dual;
739:
740: l_cont_instance_id NUMBER;
741: l_cont_name VARCHAR2(50);
742: l_description VARCHAR2(240);

Line 1354: SELECT 'NOT EMPTY' FROM DUAL

1350: p_container_id IN number,
1351: x_return_status OUT NOCOPY VARCHAR2) IS
1352:
1353: CURSOR Check_Hierarchy (v_detail_id NUMBER) IS
1354: SELECT 'NOT EMPTY' FROM DUAL
1355: WHERE EXISTS (
1356: SELECT delivery_detail_id
1357: FROM wsh_delivery_assignments
1358: WHERE parent_delivery_detail_id = v_detail_id

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

13140: x_cont_names OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.v50_Tbl_Type,
13141: x_return_status OUT NOCOPY VARCHAR2) IS
13142:
13143: CURSOR Get_Exist_Cont(v_cont_name VARCHAR2) IS
13144: SELECT NVL(MAX(1),0) FROM DUAL
13145: WHERE EXISTS ( SELECT 1 FROM WSH_DELIVERY_DETAILS
13146: WHERE container_name = v_cont_name
13147: AND container_flag = 'Y');
13148: