APPS.BOM_RESOURCES_PKG dependencies on DUAL

Line 172: CURSOR C2 IS SELECT bom_resources_s.nextval FROM sys.dual;

168: X_BATCHING_PENALTY NUMBER :=NULL --APS Enhancement for Routings
169: ) IS
170: CURSOR C IS SELECT rowid FROM BOM_RESOURCES
171: WHERE resource_id = X_Resource_Id;
172: CURSOR C2 IS SELECT bom_resources_s.nextval FROM sys.dual;
173: BEGIN
174: if (X_Resource_Id is NULL) then
175: OPEN C2;
176: FETCH C2 INTO X_Resource_Id;

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

861: X_Organization_Id NUMBER,
862: X_unique_flag IN OUT NOCOPY NUMBER) IS
863: dummy NUMBER;
864: BEGIN
865: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
866: (SELECT 1 FROM BOM_RESOURCES
867: WHERE Organization_Id = X_Organization_Id
868: AND Resource_Code = X_Resource_Code
869: AND ((X_Rowid IS NULL) OR (ROWID <> X_Rowid))