APPS.BOM_DEPARTMENTS_PKG dependencies on DUAL

Line 41: CURSOR C2 IS SELECT bom_departments_s.nextval FROM sys.dual;

37: X_Maint_Cost_Category VARCHAR2 DEFAULT NULL
38: ) IS
39: CURSOR C IS SELECT rowid FROM BOM_DEPARTMENTS
40: WHERE department_id = X_Department_Id;
41: CURSOR C2 IS SELECT bom_departments_s.nextval FROM sys.dual;
42: BEGIN
43: if (X_Department_Id is NULL) then
44: OPEN C2;
45: FETCH C2 INTO X_Department_Id;

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

340: X_Organization_Id NUMBER,
341: X_Department_Code VARCHAR2) IS
342: dummy NUMBER;
343: BEGIN
344: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
345: (SELECT 1 FROM BOM_DEPARTMENTS
346: WHERE Organization_Id = X_Organization_Id
347: AND Department_Code = X_Department_Code
348: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))