APPS.B_DEPT_CLASS_PKG dependencies on DUAL

Line 8: select 1 into dummy from dual where not exists

4: PROCEDURE Check_Unique(X_Org_Id NUMBER,
5: X_Department_Class_Code VARCHAR2) IS
6: dummy number;
7: BEGIN
8: select 1 into dummy from dual where not exists
9: (select 1
10: from bom_department_classes
11: where department_class_code = x_department_class_code
12: and organization_id = x_org_id);

Line 27: select 1 into dummy from dual where not exists

23: PROCEDURE Check_References(X_Org_Id NUMBER,
24: X_Department_Class_Code VARCHAR2) IS
25: dummy NUMBER;
26: BEGIN
27: select 1 into dummy from dual where not exists
28: (select 1
29: from bom_departments
30: where organization_id = x_org_id
31: and department_class_code = x_department_class_code);