APPS.HR_GENERAL_UTILITIES SQL Statements

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

Line: 55

  g_execute_handles.delete;

Line: 56

  g_string_cache.delete;

Line: 89

    SELECT *
    FROM per_all_people_f	-- Fix 2082000
    WHERE person_id = p_person_id
    AND trunc(p_effective_date)
    BETWEEN trunc(effective_start_date) AND trunc(effective_end_date);

Line: 151

      l_person_rec.PROGRAM_UPDATE_DATE            := l_all_person_rec.PROGRAM_UPDATE_DATE           	;

Line: 183

      l_person_rec.LAST_UPDATE_DATE               := l_all_person_rec.LAST_UPDATE_DATE              	;

Line: 184

      l_person_rec.LAST_UPDATED_BY                := l_all_person_rec.LAST_UPDATED_BY               	;

Line: 185

      l_person_rec.LAST_UPDATE_LOGIN              := l_all_person_rec.LAST_UPDATE_LOGIN             	;

Line: 237

      l_person_rec.RESUME_LAST_UPDATED            := l_all_person_rec.RESUME_LAST_UPDATED           	;

Line: 299

    SELECT last_name
           ,first_name
           ,full_name
           ,middle_names
           ,previous_last_name
           ,suffix
           ,title
           ,business_group_id
    FROM per_all_people_f
    WHERE person_id = p_person_id
    AND trunc(p_effective_date)
    BETWEEN trunc(effective_start_date) AND trunc(effective_end_date);

Line: 729

    SELECT data_length, data_precision, data_type
    FROM all_tab_columns
    WHERE table_name = p_table_name
    AND column_name = p_column_name
    AND owner = l_per_owner;

Line: 792

    SELECT lookup_type, lookup_code, meaning
    FROM hr_lookups
    WHERE lookup_type = p_lookup_type
    AND lookup_code = p_lookup_code
    AND enabled_flag = 'Y'
    AND sysdate between NVL(start_date_active, hr_api.g_sot)
      AND NVL(end_date_active, hr_api.g_eot);

Line: 805

    SELECT lookup_type, lookup_code, meaning
    FROM fnd_lookups
    WHERE lookup_type = p_lookup_type
    AND lookup_code = p_lookup_code
    AND enabled_flag = 'Y'
    AND sysdate between NVL(start_date_active, hr_api.g_sot)
      AND NVL(end_date_active, hr_api.g_eot);

Line: 873

    SELECT lookup_type, lookup_code, meaning
    FROM hr_lookups
    WHERE lookup_type = p_lookup_type
    AND enabled_flag = 'Y'
    AND sysdate between NVL(start_date_active, hr_api.g_sot)
    AND NVL(end_date_active, hr_api.g_eot)
    ORDER by meaning;

Line: 886

    SELECT lookup_type, lookup_code, meaning
    FROM fnd_lookups
    WHERE lookup_type = p_lookup_type
    AND enabled_flag = 'Y'
    AND sysdate between NVL(start_date_active, hr_api.g_sot)
    AND NVL(end_date_active, hr_api.g_eot)
    ORDER by meaning;