DBA Data[Home] [Help]

APPS.HXC_TCC_SHD SQL Statements

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

Line: 61

    select
           time_category_comp_id
          ,time_category_id
          ,ref_time_category_id
          ,component_type_id
          ,flex_value_set_id
          ,value_id
          ,is_null
          ,equal_to
          ,type
          ,object_version_number
    from	hxc_time_category_comps
    where	time_category_comp_id = p_time_category_comp_id;
Line: 137

    select
           time_category_comp_id
          ,time_category_id
          ,ref_time_category_id
          ,component_type_id
          ,flex_value_set_id
          ,value_id
          ,is_null
          ,equal_to
          ,type
          ,object_version_number
    from	hxc_time_category_comps
    where	time_category_comp_id = p_time_category_comp_id
    for	update nowait;