APPS.BOM_RESOURCE_SHIFTS_PKG dependencies on DUAL

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

7: Message_Name VARCHAR2(80);
8: Dummy NUMBER;
9: BEGIN
10: message_name := 'BOM_CANNOT_DELETE_SHIFT';
11: select 1 into dummy from dual where not exists
12: (select 1 from bom_resource_changes
13: where department_id = X_Department_Id
14: and resource_id = X_Resource_Id
15: and shift_num = X_Shift_Num);