APPS.IEM_ROUTE_CLASS_PUB SQL Statements

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

Line: 201

  select
    a.route_classification_id,
    a.procedure_name,
    a.boolean_type_code
  from
    iem_route_classifications a,
    iem_account_route_class b
  where
    a.route_classification_id = b.route_classification_id
  and
    b.enabled_flag = p_enabled_flag
  and
    b.email_account_id = p_account_id
  and
    a.route_classification_id <> 0
  order by b.priority;

Line: 221

  select
    key_type_code,
    operator_type_code,
    value
  from
    iem_route_class_rules
  where
    route_classification_id = p_route_classification_id;

Line: 314

             ruleHold.delete;

Line: 323

                 runTimekeyVals_tbl.delete;