APPS.BIS_RG_SEND_NOTIFICATIONS_PVT SQL Statements

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

Line: 50

   SELECT title, function_name, schedule_id
   FROM bis_scheduler
   WHERE schedule_id = p_schedule_id;

Line: 55

   SELECT sp.file_id, sp.title, s.function_name, s.schedule_id
   FROM bis_scheduler s, bis_schedule_preferences sp
   WHERE sp.schedule_id = p_schedule_id
   and sp.file_id = p_file_id
   and s.schedule_id = sp.schedule_id
   and sp.user_id = p_user_id
   and sp.plug_id is null;

Line: 69

  SELECT user_name INTO l_user_name
  FROM fnd_user WHERE user_id = p_user_id;

Line: 78

    select count(1)
    into l_role_exists
    from WF_LOCAL_ROLES
    where name = l_role_name;

Line: 107

  SELECT bis_excpt_wf_s.nextval
  INTO l_wf_item_key FROM dual;

Line: 143

  SELECT bis_excpt_wf_s.nextval
  INTO l_wf_item_key FROM dual;

Line: 218

    select count(*)
    into l_count
    from fnd_lobs
    where file_id = document_id;