APPS.BOM_DEPT_RES_INSTANCES_PKG dependencies on DUAL

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

271: X_Resource_Id NUMBER,
272: X_Serial_Number VARCHAR2) IS
273: dummy NUMBER;
274: BEGIN
275: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
276: (SELECT 1 FROM BOM_DEPT_RES_INSTANCES
277: WHERE instance_id = X_Instance_Id
278: And department_id = X_Department_Id
279: And resource_id = X_Resource_Id