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 973: FROM sys.dual;

969:
970: CURSOR C_Del_detail_ID
971: IS
972: SELECT wsh_delivery_details_s.nextval
973: FROM sys.dual;
974:
975: l_row_count NUMBER;
976: l_temp_id NUMBER;
977:

Line 1534: FROM sys.dual;

1530:
1531:
1532: CURSOR C_Del_Assign_ID
1533: IS SELECT wsh_delivery_assignments_s.nextval
1534: FROM sys.dual;
1535:
1536: l_row_count NUMBER;
1537: l_temp_id NUMBER;
1538:

Line 1651: FROM sys.dual;

1647:
1648: CURSOR C_Del_detail_ID
1649: IS
1650: SELECT wsh_delivery_details_s.nextval
1651: FROM sys.dual;
1652:
1653: CURSOR C_Check_Detail_ID
1654: IS SELECT rowid
1655: FROM wsh_delivery_details

Line 4289: FROM sys.dual;

4285: WHERE delivery_assignment_id = x_delivery_assignment_id;
4286:
4287: CURSOR C_Del_Assign_ID
4288: IS SELECT wsh_delivery_assignments_s.nextval
4289: FROM sys.dual;
4290:
4291: CURSOR C_Check_Assignment_ID
4292: IS
4293: SELECT rowid