APPS.IRC_GRANTS_UTIL SQL Statements

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

Line: 15

  select fu.user_id, fu.user_name, furg.security_group_id
  from
  fnd_user fu, fnd_user_resp_groups furg
  where furg.responsibility_id = p_resp_id
  and furg.user_id=fu.user_id
  and fu.user_id > 1000
  and trunc(sysdate) between nvl(fu.start_date,trunc(sysdate)) and nvl(fu.end_date,trunc(sysdate))
  and not exists (select /*+ NO_UNNEST */1 from fnd_grants where grantee_type='USER' and grantee_key=fu.user_name
  and ctx_resp_id=furg.responsibility_id and menu_id=p_menu_id);

Line: 26

  select menu_id from fnd_menus where menu_name=upper(p_permission_set);

Line: 29

  select responsibility_id, application_id
  from fnd_responsibility where responsibility_key=upper(p_resp_key);

Line: 68

    l_user_id_tbl.delete;

Line: 69

    l_user_name_tbl.delete;

Line: 70

    l_sec_group_id_tbl.delete;