APPS.HR_PAE_BUS SQL Statements

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

Line: 30

  select hpe.rowid
  from   hr_pattern_exceptions hpe
  where  upper(hpe.exception_name) = upper(p_exception_name);

Line: 75

  select h.rowid
  from   hr_lookups h
  where  h.lookup_type = 'EXCEPTION_CATEGORY'
    and  h.lookup_code = p_exception_category;

Line: 151

    select bit1.time_unit_multiplier tum,
	   bit1.base_time_unit btu,
	   con1.sequence_no,
	   0
    from   hr_pattern_constructions  con1,
	   hr_pattern_bits           bit1
    where  bit1.pattern_bit_id = con1.pattern_bit_id
      and  con1.pattern_id     = p_pattern_id
    union all
    select bit2.time_unit_multiplier tum,
	   bit2.base_time_unit btu,
	   con2.sequence_no,
	   con3.sequence_no
    from   hr_pattern_bits           bit2,
	   hr_pattern_constructions  con2,
	   hr_pattern_constructions  con3
    where  bit2.pattern_bit_id = con3.pattern_bit_id
      and  con2.component_pattern_id = con3.pattern_id
      and  con2.pattern_id = p_pattern_id
    order by 3,4;

Line: 187

Procedure insert_validate(p_rec in out hr_pae_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 218

End insert_validate;

Line: 223

Procedure update_validate(p_rec in out hr_pae_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 266

End update_validate;

Line: 271

Procedure delete_validate(p_rec in hr_pae_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 281

End delete_validate;