DBA Data[Home] [Help]

APPS.HXC_HAS_SHD SQL Statements

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

Line: 60

    select
       approval_style_id
      ,object_version_number
      ,name
      ,business_group_id
      ,legislation_code
      ,description
      ,run_recipient_extensions
      ,admin_role
      ,error_admin_role
    from	hxc_approval_styles
    where	approval_style_id = p_approval_style_id;
Line: 134

    select
       approval_style_id
      ,object_version_number
      ,name
      ,business_group_id
      ,legislation_code
      ,description
      ,run_recipient_extensions
      ,admin_role
      ,error_admin_role
    from	hxc_approval_styles
    where	approval_style_id = p_approval_style_id
    for	update nowait;