APPS.BIS_RSG_PUB_APIS_PKG SQL Statements

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

Line: 16

    select request_set_name from fnd_request_sets where request_set_id= req_id;

Line: 19

    select
       req.argument2
     from
       fnd_concurrent_requests req
     where
       req.request_id = req_id and
       req_id=PRIORITY_REQUEST_ID
       and has_sub_request = 'Y';

Line: 113

  SELECT OPTION_VALUE FROM BIS_REQUEST_SET_OPTIONS where
  OPTION_NAME='REFRESH_MODE' and REQUEST_SET_NAME=upper(rs_name)
  and set_app_id = 191;

Line: 173

  select object_name,object_type from bis_request_set_objects
  where request_set_name = upper(rs_name) and set_app_id = 191;

Line: 177

  select object_name,object_type from bis_request_set_objects
  where request_set_name = upper(rs_name) and object_type = con_type and set_app_id = 191;