DBA Data[Home] [Help]

APPS.HXC_ULP_SHD SQL Statements

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

Line: 59

    select
       layout_comp_prompt_id
      ,layout_component_id
      ,prompt_alias
      ,prompt_type
      ,region_code
      ,region_application_id
      ,attribute_code
      ,attribute_application_id
      ,object_version_number
    from	hxc_layout_comp_prompts
    where	layout_comp_prompt_id = p_layout_comp_prompt_id;
Line: 133

    select
       layout_comp_prompt_id
      ,layout_component_id
      ,prompt_alias
      ,prompt_type
      ,region_code
      ,region_application_id
      ,attribute_code
      ,attribute_application_id
      ,object_version_number
    from	hxc_layout_comp_prompts
    where	layout_comp_prompt_id = p_layout_comp_prompt_id
    for	update nowait;