APPS.PA_BILLING_EXTENSIONS_PKG SQL Statements

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

Line: 15

  select 1
  into   x_dummy
  from   sys.dual
  where  not exists
                  (select 1
                   from   pa_billing_extensions
                   where  name = x_name
                   and    ((x_rowid is NULL) or (rowid <> x_rowid)));

Line: 43

  select 1
  into   x_dummy
  from   sys.dual
  where  not exists
                  (select 1
                   from   pa_billing_extensions
                   where  processing_order = x_order
                   and    ((x_rowid is NULL) or (rowid <> x_rowid)));

Line: 73

    select 1
    into x_dummy
    from sys.dual
    where not exists
          ( select 1
            from pa_billing_assignments
            where billing_extension_id = x_bill_extension_id );

Line: 104

    select 1 into x_dummy
     from sys.dual
     where not exists ( select 1
                         from pa_billing_assignments
                         where billing_extension_id = x_bill_extension_id
                           and billing_assignment_id in
                              ( select billing_assignment_id
                               from pa_events ));

Line: 131

   select pa_billing_extensions_s.nextval into x_nextval
   from sys.dual;