APPS.HXC_WF_ERROR_HELPER SQL Statements

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

Line: 45

SELECT tcsum.resource_id,
       tcsum.start_time,
       tcsum.stop_time
  FROM hxc_timecard_summary tcsum
 WHERE  tcsum.timecard_id = p_tc_bbid;

Line: 55

 select htb.resource_id, htb.start_time,htb.stop_time
 from hxc_time_building_blocks htb
 where htb.time_building_block_id  =p_tc_bbid
 and htb.scope = 'TIMECARD'
 and htb.object_version_number = (select max(object_version_number)
                                  from hxc_time_building_blocks htb1
                                  where htb.time_building_block_id =htb1.time_building_block_id);

Line: 66

select error_message
from WF_ITEM_ACTIVITY_STATUSES
where item_type = 'HXCEMP'
and item_key = p_itemkey
and activity_status = 'ERROR';

Line: 75

select parent_item_key
from wf_items
where item_key = itemkey;

Line: 192

select display_name
into l_item_type_desc
from wf_item_types_vl
where name = 'HXCEMP';