APPS.WSH_DELIVERY_DETAILS_PKG dependencies on DUAL

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

39: others exception;
40:
41: -- bug 3022644 - Cursor to check whether container name is already exist
42: CURSOR Get_Exist_Cont(v_cont_name VARCHAR2,v_wms_flag NUMBER) IS
43: SELECT NVL(MAX(1),0) FROM DUAL
44: WHERE EXISTS ( SELECT 1 FROM WSH_DELIVERY_DETAILS
45: WHERE container_name = v_cont_name
46: AND container_flag = 'Y'
47: -- LPN reuse project

Line 183: FROM sys.dual;

179: /* lpn conv
180: CURSOR C_Del_detail_ID
181: IS
182: SELECT wsh_delivery_details_s.nextval
183: FROM sys.dual;
184:
185: */
186:
187:

Line 1007: FROM sys.dual;

1003:
1004: CURSOR C_Del_detail_ID
1005: IS
1006: SELECT wsh_delivery_details_s.nextval
1007: FROM sys.dual;
1008:
1009: l_row_count NUMBER;
1010: l_temp_id NUMBER;
1011:

Line 1671: FROM sys.dual;

1667:
1668:
1669: CURSOR C_Del_Assign_ID
1670: IS SELECT wsh_delivery_assignments_s.nextval
1671: FROM sys.dual;
1672:
1673: l_row_count NUMBER;
1674: l_temp_id NUMBER;
1675:

Line 1788: FROM sys.dual;

1784:
1785: CURSOR C_Del_detail_ID
1786: IS
1787: SELECT wsh_delivery_details_s.nextval
1788: FROM sys.dual;
1789:
1790: CURSOR C_Check_Detail_ID
1791: IS SELECT rowid
1792: FROM wsh_delivery_details

Line 4424: FROM sys.dual;

4420: WHERE delivery_assignment_id = x_delivery_assignment_id;
4421:
4422: CURSOR C_Del_Assign_ID
4423: IS SELECT wsh_delivery_assignments_s.nextval
4424: FROM sys.dual;
4425:
4426: CURSOR C_Check_Assignment_ID
4427: IS
4428: SELECT rowid