APPS.B_DEPT_CLASS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

  select 1 into dummy from dual where not exists
    (select 1
     from   bom_department_classes
     where  department_class_code = x_department_class_code
     and    organization_id = x_org_id);

Line: 27

  select 1 into dummy from dual where not exists
    (select 1
     from   bom_departments
     where  organization_id = x_org_id
     and    department_class_code = x_department_class_code);