APPS.HXC_TIMECARD_ATTRIBUTES_PKG SQL Statements

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

Line: 28

SELECT
decode(hta.attribute_category,
p_context, decode(p_segment,
'ATTRIBUTE1' , hta.attribute1,
'ATTRIBUTE2' , hta.attribute2,
'ATTRIBUTE3' , hta.attribute3,
'ATTRIBUTE4' , hta.attribute4,
'ATTRIBUTE5' , hta.attribute5,
'ATTRIBUTE6' , hta.attribute6,
'ATTRIBUTE7' , hta.attribute7,
'ATTRIBUTE8' , hta.attribute8,
'ATTRIBUTE9' , hta.attribute9,
'ATTRIBUTE10' , hta.attribute10,
'ATTRIBUTE11' , hta.attribute11,
'ATTRIBUTE12' , hta.attribute12,
'ATTRIBUTE13' , hta.attribute13,
'ATTRIBUTE14' , hta.attribute14,
'ATTRIBUTE15' , hta.attribute15,
'ATTRIBUTE16' , hta.attribute16,
'ATTRIBUTE17' , hta.attribute17,
'ATTRIBUTE18' , hta.attribute18,
'ATTRIBUTE19' , hta.attribute19,
'ATTRIBUTE20' , hta.attribute20,
'ATTRIBUTE21' , hta.attribute21,
'ATTRIBUTE22' , hta.attribute22,
'ATTRIBUTE23' , hta.attribute23,
'ATTRIBUTE24' , hta.attribute24,
'ATTRIBUTE25' , hta.attribute25,
'ATTRIBUTE26' , hta.attribute26,
'ATTRIBUTE27' , hta.attribute27,
'ATTRIBUTE28' , hta.attribute28,
'ATTRIBUTE29' , hta.attribute29,
'ATTRIBUTE30' , hta.attribute30
),
null)
FROM hxc_time_building_blocks htb,
     hxc_time_attribute_usages htau,
     hxc_time_attributes hta
WHERE
    htb.time_building_block_id = bb_id
and htb.object_version_number = bb_ovn
and htb.time_building_block_id = htau.time_building_block_id
and htb.object_version_number = htau.time_building_block_ovn
and htau.time_attribute_id  = hta.time_attribute_id
and htb.resource_type = 'PERSON'
and htb.date_to = hr_general.end_of_time
and htb.scope = 'DETAIL';

Line: 78

SELECT hma.context,hma.segment
FROM hxc_mapping_attributes_v hma
WHERE hma.map = p_map
and   hma.field_name = p_field_name;