APPS.PER_FNAME_PKG SQL Statements

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

Line: 49

    SELECT 'x'
    FROM   hr_legislation_installations
    WHERE  application_short_name = 'PER'
                   AND (status='I' OR action IS NOT NULL)
                   AND legislation_code = p_legislation_code;

Line: 58

    SELECT 'x'
    FROM user_objects
    WHERE object_type='PACKAGE BODY'
      AND object_name LIKE 'HR_'||p_legislation_code||'_UTILITY'
      AND length(object_name)=13
    ORDER BY object_name;

Line: 67

     select person_id,
            effective_start_date,
            effective_end_date
     from per_all_people_f per, per_business_groups bg
     where per.business_group_id = bg.business_group_id
     and   bg.legislation_code = p_legislation_code;

Line: 78

     select person_id,
            effective_start_date,
            effective_end_date,
            first_name,
            middle_names,
            last_name,
            known_as,
            title,
            suffix,
            date_of_birth,
            per.business_group_id,
            full_name
     from per_all_people_f per, per_business_groups bg
     where per.business_group_id = bg.business_group_id
     and   bg.legislation_code = p_legislation_code;

Line: 197

           UPDATE  per_all_people_f
           SET last_name = last_name
           WHERE person_id = l_person_id_list(j)
                and effective_start_date = l_effective_start_date_list(j)
                and effective_end_date   = l_effective_end_date_list(j);

Line: 266

            UPDATE  per_all_people_f
            SET full_name = l_full_name_list(j)  -- Fix 3386992
            WHERE person_id = l_person_id_list(j)
                and effective_start_date = l_effective_start_date_list(j)
                and effective_end_date   = l_effective_end_date_list(j);