APPS.BIS_RESPONSIBILITY_PVT SQL Statements

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

Line: 39

 select a.responsibility_id,
        a.responsibility_key,
        a.responsibility_name
 from fnd_responsibility_vl a,
      fnd_user_resp_groups b
 where b.user_id = p_user_id
 and   b.responsibility_id = a.responsibility_id
 and   b.start_date <= sysdate
 and   (b.end_date is null or b.end_date >= sysdate)
 and   a.start_date <= sysdate
 and   (a.end_date is null or a.end_date >= sysdate)
 and   a.version = 'W'
 order by responsibility_name;

Line: 96

 select a.responsibility_id,
        a.responsibility_key,
        a.responsibility_name
 from fnd_responsibility_vl a,
      fnd_user_resp_groups b
 where b.user_id = p_user_id
 and   b.responsibility_id = a.responsibility_id
 and   b.start_date <= sysdate
 and   (b.end_date is null or b.end_date >= sysdate)
 and   a.start_date <= sysdate
 and   (a.end_date is null or a.end_date >= sysdate)
 and   a.version like p_version
 order by responsibility_name;

Line: 157

select RESPONSIBILITY_ID
     , RESPONSIBILITY_KEY
     , RESPONSIBILITY_NAME
from fnd_responsibility_vl
where VERSION='W'
and start_date <= sysdate
 and nvl(end_date, sysdate) >= sysdate
order by RESPONSIBILITY_NAME;

Line: 209

    select RESPONSIBILITY_ID
         , RESPONSIBILITY_KEY
         , RESPONSIBILITY_NAME
    into x_Responsibility_Rec.RESPONSIBILITY_ID
       , x_Responsibility_Rec.RESPONSIBILITY_SHORT_NAME
       , x_Responsibility_Rec.RESPONSIBILITY_NAME
    from fnd_responsibility_vl
    where VERSION='W'
    and start_date <= sysdate
    and nvl(end_date, sysdate) >= sysdate
    and RESPONSIBILITY_ID=p_Responsibility_Rec.RESPONSIBILITY_ID;

Line: 297

  SELECT DISPLAY_NAME
  FROM wf_role_lov_vl
  WHERE NAME =  p_Notify_resp_short_name;

Line: 474

    SELECT
          attribute_code
    FROM ak_region_items_vl
    WHERE region_code = l_region_code
    AND   region_application_id = l_region_app_id
    AND   attribute_application_id = l_attribute_app_id;