DBA Data[Home] [Help]

APPS.HXC_HAD_SHD SQL Statements

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

Line: 54

    select
       alias_definition_id
      ,description
      ,alias_definition_name
      ,alias_context_code
      ,business_group_id
      ,legislation_code
      ,timecard_field
      ,object_version_number
      ,alias_type_id
    from	hxc_alias_definitions
    where	alias_definition_id = p_alias_definition_id;
Line: 128

    select
       alias_definition_id
      ,description
      ,alias_definition_name
      ,alias_context_code
      ,business_group_id
      ,legislation_code
      ,timecard_field
      ,object_version_number
      ,alias_type_id
    from	hxc_alias_definitions
    where	alias_definition_id = p_alias_definition_id
    for	update nowait;