APPS.HXC_SECURITY SQL Statements

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

Line: 16

   select 1
     from hxc_entity_group_comps egc,
          hxc_time_recipients tr
    where egc.entity_group_id = p_application_set_id
      and egc.entity_id = tr.time_recipient_id
      and tr.name = 'Projects';

Line: 88

p_list.delete;

Line: 235

  select ta.time_attribute_id
        ,tau.time_building_block_id
        ,ta.attribute_category
        ,ta.attribute1
        ,ta.attribute2
        ,ta.attribute3
        ,ta.attribute4
        ,ta.attribute5
        ,ta.attribute6
        ,ta.attribute7
        ,ta.attribute8
        ,ta.attribute9
        ,ta.attribute10
        ,ta.attribute11
        ,ta.attribute12
        ,ta.attribute13
        ,ta.attribute14
        ,ta.attribute15
        ,ta.attribute16
        ,ta.attribute17
        ,ta.attribute18
        ,ta.attribute19
        ,ta.attribute20
        ,ta.attribute21
        ,ta.attribute22
        ,ta.attribute23
        ,ta.attribute24
        ,ta.attribute25
        ,ta.attribute26
        ,ta.attribute27
        ,ta.attribute28
        ,ta.attribute29
        ,ta.attribute30
        ,ta.object_version_number
        ,tau.time_building_block_ovn
        ,ta.bld_blk_info_type_id
        ,bbit.bld_blk_info_type
   from  hxc_time_attributes ta
        ,hxc_time_attribute_usages tau
        ,hxc_bld_blk_info_types bbit
  where  ta.time_attribute_id = tau.time_attribute_id
    and  tau.time_building_block_id = p_block_id
    and  tau.time_building_block_ovn = p_block_ovn
    and  ta.attribute_category = hxc_timecard.c_security_attribute
    and  ta.bld_blk_info_type_id = bbit.bld_blk_info_type_id;