APPS.HR_SECURITY SQL Statements

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

Line: 115

   SELECT security_profile_id
     FROM per_security_profiles
    WHERE reporting_oracle_username = USER;

Line: 159

  select named_person_id
  from per_security_profiles
  where security_profile_id=p_security_profile_id;

Line: 164

  select employee_id
  from fnd_user
  where user_id=p_user_id;

Line: 245

  SELECT DECODE(READ_ONLY_FLAG,'U', 'Y'
                              ,'M', 'Y'
                              ,'K', 'Y'
                              ,'N') schema_mode,
         DECODE(SUBSTRB(USERENV('CLIENT_INFO'), 1, 1),' ', NULL,
                SUBSTRB(USERENV('CLIENT_INFO'),1, 10))
           FROM FND_ORACLE_USERID
          WHERE ORACLE_USERNAME = user;

Line: 259

  SELECT *
    FROM per_security_profiles
   WHERE security_profile_id = p_security_profile_id;

Line: 269

  SELECT vacancy_id
    FROM irc_rec_team_members
  WHERE person_id = p_person_id;

Line: 278

  SELECT fndu.employee_id
  FROM   fnd_user fndu
  WHERE  p_user_id IS NOT NULL
  AND    fndu.user_id = p_user_id;

Line: 290

  select person_id
    from per_person_list
   where security_profile_id=p_security_profile_id
   and   granted_user_id is null;

Line: 302

  select asg.person_id
    from (select a.person_id,
                 a.supervisor_id
            from per_all_assignments_f a
            where trunc(sysdate) between a.effective_start_date
	                             and a.effective_end_date
              and assignment_type <> 'B') asg
   connect by asg.supervisor_id = prior asg.person_id
          and Level<=nvl(p_max_levels,Level)+1
   start with asg.person_id=p_top_person_id;

Line: 316

  select asg.person_id
    from (select a.person_id,
                 a.supervisor_id
            from per_all_assignments_f a
           where trunc(sysdate) between a.effective_start_date
	                            and a.effective_end_date
             and assignment_type <> 'B') asg
   where exists (select null
                   from per_person_list ppl
                  where ppl.security_profile_id=p_security_profile_id
                    and ppl.person_id=asg.person_id)
  connect by asg.supervisor_id = prior asg.person_id
         and Level<=nvl(p_max_levels,Level)+1
  start with asg.person_id=p_top_person_id ;

Line: 333

  select asg.person_id
    from (select a.person_id,
                 a.supervisor_id
            from per_all_assignments_f a
            where trunc(sysdate) between a.effective_start_date
	                             and a.effective_end_date
              and assignment_type <> 'B'
              and a.primary_flag='Y') asg
  connect by asg.supervisor_id = prior person_id
         and Level<=nvl(p_max_levels,Level)+1
  start with asg.person_id=p_top_person_id ;

Line: 348

  select asg.person_id
    from (select a.person_id,
                 a.supervisor_id
            from per_all_assignments_f a
           where trunc(sysdate) between a.effective_start_date
	                            and a.effective_end_date
             and assignment_type <> 'B'
             and a.primary_flag='Y' ) asg
   where exists (select null
                   from per_person_list ppl
                  where ppl.security_profile_id=p_security_profile_id
                    and ppl.person_id=asg.person_id)
  connect by asg.supervisor_id = prior asg.person_id
         and Level<=nvl(p_max_levels,Level)+1
  start with asg.person_id=p_top_person_id ;

Line: 661

      hr_security_internal.g_per_tbl.delete(g_person_id);

Line: 1030

   SELECT 1
     FROM per_organization_list
    WHERE security_profile_id = get_security_profile
      AND organization_id = p_organization_id;

Line: 1057

   SELECT 1
     FROM per_position_list
    WHERE security_profile_id = get_security_profile
      AND position_id = p_position_id;

Line: 1085

   SELECT 1
     FROM pay_payroll_list
    WHERE security_profile_id = get_security_profile
      AND payroll_id = p_payroll_id;

Line: 2075

     Select 1
       from irc_rec_team_members team
           ,per_all_people_f  per
           ,fnd_user usr
      where team.vacancy_id  = p_vacancy_id
        and team.party_id    = nvl(per.party_id, usr.customer_id)
        and per.person_id(+) = usr.employee_id
        and sysdate          between per.effective_start_date
	                         and per.effective_end_date
        and usr.user_id      = g_user_id;

Line: 2307

     SELECT null
     FROM   org_access oa
     WHERE  oa.resp_application_id = g_resp_appl_id
     AND    oa.responsibility_id = g_resp_id;

Line: 2318

     SELECT oa.organization_id
     FROM   org_access oa
     WHERE  oa.resp_application_id = g_resp_appl_id
     AND    oa.responsibility_id = g_resp_id
     AND    oa.organization_id = p_org_id;

Line: 2328

     SELECT null
     FROM   hr_organization_information oi
     WHERE  oi.organization_id = p_org_id
     AND    oi.org_information_context = 'Accounting Information'
     AND    to_number(oi.org_information3) = org_id;

Line: 2559

      hr_security_internal.g_per_tbl.delete(p_person_id);

Line: 2716

  PROCEDURE delete_list_for_bg(p_business_group_id NUMBER)
  IS
  BEGIN
    hr_security_internal.delete_security_list_for_bg(p_business_group_id);

Line: 2723

  PROCEDURE delete_per_from_list(p_person_id   number)
  IS
  BEGIN
    hr_security_internal.delete_per_from_security_list(p_person_id);

Line: 2730

  PROCEDURE delete_org_from_list(p_organization_id    number)
  IS
  BEGIN
    hr_security_internal.delete_org_from_security_list(p_organization_id);

Line: 2737

  PROCEDURE delete_pos_from_list(p_position_id    number)
  IS
  BEGIN
    hr_security_internal.delete_pos_from_security_list(p_position_id);

Line: 2744

  PROCEDURE delete_payroll_from_list(p_payroll_id     number)
  IS
  BEGIN
    hr_security_internal.delete_pay_from_security_list(p_payroll_id);