APPS.AMW_SECURITY_UTILS_PVT SQL Statements

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

Line: 33

cursor c is (select parent_role_name, child_obj_name,
                    child_role_name, child_instance_set_id
from amw_security_role_mappings where parent_obj_name = p_parent_obj_name
and  (parent_role_name = p_parent_role or parent_role_name = 'ANY'));

Line: 109

procedure update_dependant_grants(p_grant_guid in raw,
                                  p_new_start_date in date,
                                  p_new_end_date in date,
                                  x_success  OUT NOCOPY VARCHAR /* Boolean */)
is
l_api_name constant varchar2(30) := 'update_dependant_grants';

Line: 128

is select grant_guid from fnd_grants where
parameter10 = p_grant_guid;

Line: 153

      fnd_grants_pkg.update_grant(p_api_version  => g_api_version,
                                  p_grant_guid   => guid_tbl(i),
                                  p_start_date   => l_start_date,
                                  p_end_date     => p_new_end_date,
                                  x_success      => x_success);

Line: 167

end update_dependant_grants;

Line: 181

is select grant_guid from fnd_grants where
parameter10 = p_grant_guid;

Line: 217

  select party_id into l_party_id
  from amw_employees_current_v
  where employee_id = (select employee_id from fnd_user where user_name = FND_GLOBAL.user_name)
  and   rownum = 1;