APPS.HR_SEC3_UPDATE SQL Statements

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

Line: 79

   select bg.business_group_id,
          bg.name,
          sp.security_profile_id,
          sp.security_profile_name
   from   per_security_profiles sp,
          per_business_groups   bg
   where  sp.security_profile_id = nvl(p_sp_id,sp.security_profile_id)
   and    sp.business_group_id   = nvl(p_bg_id,sp.business_group_id)
   and    sp.business_group_id   = bg.business_group_id
   and    sp.view_all_flag       = decode(bg.business_group_id,null,
                                          sp.view_all_flag,'Y') ;

Line: 102

   select distinct (responsibility_id),
	  security_profile_id
   from   per_sec_profile_assignments
   where  responsibility_id      = p_resp_id;

Line: 124

       select V.PROFILE_OPTION_VALUE
       from   FND_PROFILE_OPTIONS O, FND_PROFILE_OPTION_VALUES V
       where  O.PROFILE_OPTION_NAME = option_name
       and    V.LEVEL_ID = 10003 and V.LEVEL_VALUE = to_char(resp_id)
       and    V.LEVEL_VALUE_APPLICATION_ID = to_char(appl_id)
       and    O.PROFILE_OPTION_ID = V.PROFILE_OPTION_ID
       and    O.APPLICATION_ID    = V.APPLICATION_ID ;

Line: 166

        for resp in ( select responsibility_id,
                             responsibility_name,
			     application_id
		      from   fnd_responsibility_vl
                      order by responsibility_name )
        loop

             get_resp_level (
                option_name  => 'PER_BUSINESS_GROUP_ID',
                appl_id      => resp.application_id,
                resp_id      => resp.responsibility_id,
                option_value => l_resp_value,
                defined      => l_resp_defined ) ;