APPS.HR_DE_GENERAL SQL Statements

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

Line: 7

        select uci.value
        from pay_user_column_instances_f uci, pay_user_rows_f ur,
        pay_user_tables ut
        where ut.user_table_name = 'HR_DE_COUNTRY_CODE'
        and ur.row_low_range_or_name = l_legislation_code
        and ur.user_table_id = ut.user_table_id
        and ur.user_row_id = uci.user_row_id;

Line: 274

    select fcu.currency_code
    from   hr_organization_information hoi,
           hr_organization_units hou,
           fnd_currencies fcu
    where  hou.business_group_id       = c_business_group_id
    and    hou.organization_id         = hoi.organization_id
    and    hoi.org_information_context = 'Business Group Information'
    and    fcu.issuing_territory_code  = hoi.org_information9;

Line: 306

  select tax_info.org_information1,
	 org.name
    into tax_office_number,
	 tax_office_name
  from   hr_organization_information tax_info ,
	 hr_organization_units org
  where  tax_info.organization_id = org.organization_id
    and  tax_info.organization_id = p_organization_id
    and  TAX_INFO.org_information_context = 'DE_TAX_OFFICE_INFO';

Line: 336

     SELECT value
     FROM   pay_user_column_instances_f uci
           ,pay_user_columns            uc
     WHERE  uc.user_table_id    = p_user_table_id
       AND  uc.user_column_name = p_user_column_name
       AND  uci.user_row_id     = p_user_row_id
       AND  uci.user_column_id  = uc.user_column_id
       AND  p_effective_date    BETWEEN uci.effective_start_date
                                    AND uci.effective_end_date;

Line: 364

  select name into p_org_name_out
  from hr_all_organization_units
  where organization_id = p_org_id;

Line: 385

  select max(effective_start_date)
  into l_max_effective_start_date
  from pay_element_entries_f
  where element_entry_id = p_element_entry_id;

Line: 400

SELECT end_reason_number FROM pqh_de_ins_end_reasons
WHERE ins_end_reason_id = p_end_reason_id;

Line: 419

SELECT end_reason_description FROM pqh_de_ins_end_reasons
WHERE ins_end_reason_id = p_end_reason_id;