APPS.PER_ZA_USER_HOOK_PKG SQL Statements

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

Line: 35

         SELECT typ.system_person_type
           FROM per_person_types typ
          WHERE typ.person_type_id     = p_person_type_id;

Line: 239

      SELECT person_type_id
        FROM per_all_people_f
       WHERE person_id = p_person_id
         AND p_effective_date BETWEEN effective_start_date
                                  AND effective_end_date;

Line: 246

      SELECT per_information4
        FROM per_all_people_f
       WHERE person_id = p_person_id
         AND p_effective_date BETWEEN effective_start_date
                                  AND effective_end_date;