APPS.HR_SUMMARY_UTIL SQL Statements

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

Line: 31

select lookup_code
from   hr_lookups
where  lookup_type = p_lookup_type;

Line: 89

select ur.ROW_LOW_RANGE_OR_NAME name
,      uci1.value value
from pay_user_column_instances_f uci1
,    pay_user_rows_f ur
,    pay_user_columns uc1
,    pay_user_tables t
where uci1.USER_ROW_ID = ur.USER_ROW_ID
and   sysdate between ur.effective_start_date and ur.effective_end_date
and   uci1.USER_COLUMN_ID = uc1.USER_COLUMN_ID
and   sysdate between uci1.effective_start_date and uci1.effective_end_date
and   uc1.USER_COLUMN_NAME = p_column
and   ur.user_table_id = t.user_table_id
and   uc1.user_table_id = t.user_table_id
and   t.USER_TABLE_NAME = p_table_name
and   uci1.value is not null
and   t.business_group_id = g_business_group_id;

Line: 166

select ur.ROW_LOW_RANGE_OR_NAME name
,      uci1.value low_value
,      uci2.value high_value
,      ur.display_sequence
from pay_user_column_instances_f uci1
,    pay_user_column_instances_f uci2
,    pay_user_rows_f ur
,    pay_user_columns uc1
,    pay_user_columns uc2
,    pay_user_tables t
where uci1.USER_ROW_ID = ur.USER_ROW_ID
and   sysdate between ur.effective_start_date and ur.effective_end_date
and   uci1.USER_COLUMN_ID = uc1.USER_COLUMN_ID
and   sysdate between uci1.effective_start_date and uci1.effective_end_date
and   uci2.USER_ROW_ID = ur.USER_ROW_ID
and   uci2.USER_COLUMN_ID = uc2.USER_COLUMN_ID
and   sysdate between uci2.effective_start_date and uci2.effective_end_date
and   uc1.USER_COLUMN_NAME = p_low_column
and   uc2.USER_COLUMN_NAME = p_high_column
and   ur.user_table_id = t.user_table_id
and   uc1.user_table_id = t.user_table_id
and   uc2.user_table_id = t.user_table_id
and   t.USER_TABLE_NAME = p_table_name
and   nvl(to_char(t.business_group_id),t.legislation_code) = decode(t.business_group_id,null,l_legislation_code,to_char(g_business_group_id));

Line: 198

   select legislation_code
     into l_legislation_code
     from per_business_groups
     where business_group_id = g_business_group_id;

Line: 351

select fsv.id_flex_num            id_flex_num
,      fsv.id_flex_structure_name structure_name
,      uci1.value                 segment_value
,      ur.display_sequence
from pay_user_column_instances_f uci1
,    pay_user_rows_f ur
,    pay_user_columns uc1
,    pay_user_tables t
,    fnd_id_flex_structures_vl fsv
where uci1.USER_ROW_ID = ur.USER_ROW_ID
and sysdate between ur.effective_start_date and ur.effective_end_date
and uci1.USER_COLUMN_ID = uc1.USER_COLUMN_ID
and sysdate between uci1.effective_start_date and uci1.effective_end_date
and uc1.USER_COLUMN_NAME = p_column_name
and ur.user_table_id = t.user_table_id
and uc1.user_table_id = t.user_table_id
and t.USER_TABLE_NAME = p_table_name
and ur.ROW_LOW_RANGE_OR_NAME = fsv.id_flex_structure_name
and fsv.id_flex_code = 'CAGR'
and fsv.application_id = 800
and t.business_group_id = g_business_group_id;

Line: 395

      l_stmt := 'select distinct '||l_seg_string||
                ' from per_cagr_grades_def cagr_def '||
                ' ,    per_cagr_grades cgr'||
                ' ,    per_cagr_grade_structures cgs'||
                ' ,    per_collective_agreements cag'||
                ' where cgs.id_flex_num = '||l_rec.id_flex_num||
                ' and cagr_def.cagr_grade_def_id = cgr.cagr_grade_def_id'||
                ' and cgr.cagr_grade_structure_id = cgs.cagr_grade_structure_id'||
                ' and cgs.collective_agreement_id = cag.collective_agreement_id'||
                ' and cag.business_group_id = '||to_char(g_business_group_id);

Line: 458

      l_stmt := 'select to_char(to_date('||''''||'1999'||lpad(to_char(i),2,'0')||'01'||''''||',''YYYYMMDD''),''MON'') from dual';