APPS.HR_SIGNON SQL Statements

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

Line: 73

         SELECT business_group_id
           INTO l_business_group_id
           FROM per_business_groups
          WHERE security_group_id = to_char(p_security_group_id);

Line: 127

   SELECT 'Y'
     FROM per_business_groups
    WHERE security_group_id = to_char(p_security_group_id)
      AND business_group_id = l_business_group_id;

Line: 235

   SELECT p1.security_profile_id
     FROM per_sec_profile_assignments p1
         ,per_security_profiles p2
    WHERE p1.security_profile_id = p2.security_profile_id
      AND p1.user_id = p_user_id
      AND p1.responsibility_id = p_responsibility_id
      AND p1.responsibility_application_id = p_resp_app_id
      AND p1.business_group_id = p_business_group_id
      AND p1.security_group_id = p_security_group_id
     -- AND SYSDATE BETWEEN p1.start_date -- modified for the bug 6344997
      AND trunc(SYSDATE) BETWEEN p1.start_date
                      AND NVL(p1.end_date, hr_general.END_OF_TIME);

Line: 250

   SELECT MIN(security_profile_id)
     FROM per_security_profiles
    WHERE business_group_id = p_business_group_id
      AND view_all_flag = 'Y';

Line: 349

   SELECT 'Y'
     FROM per_business_groups
    WHERE business_group_id <> 0
      AND security_group_id = '0';

Line: 604

           select *
           into   hr_signon.g_hr_security_profile
           from   per_security_profiles
           where  security_profile_id = l_security_profile_id;