APPS.BOM_SETUP_TYPES_PKG dependencies on DUAL

Line 34: CURSOR C2 IS SELECT bom_setup_types_s.nextval FROM sys.dual;

30: ) IS
31:
32: CURSOR C IS SELECT rowid FROM BOM_SETUP_TYPES
33: WHERE setup_id = x_setup_id;
34: CURSOR C2 IS SELECT bom_setup_types_s.nextval FROM sys.dual;
35:
36: BEGIN
37: if (x_setup_id is NULL) then
38: OPEN C2;

Line 280: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS

276: PROCEDURE Check_Unique(X_Organization_Id NUMBER,
277: X_Setup_Code VARCHAR2) IS
278: dummy NUMBER;
279: BEGIN
280: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
281: (SELECT 1 FROM BOM_SETUP_TYPES
282: WHERE Organization_Id = X_Organization_Id
283: AND Setup_Code = X_Setup_Code
284: );