APPS.HXC_HTR_SHD SQL Statements

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

Line: 61

    select
       time_recipient_id
      ,name
      ,application_id
      ,object_version_number
      ,application_retrieval_function
      ,application_update_process
      ,appl_validation_process
      ,application_period_function
      ,appl_dynamic_template_process
      ,extension_function1
      ,extension_function2
    from	hxc_time_recipients
    where	time_recipient_id = p_time_recipient_id;

Line: 137

    select
       time_recipient_id
      ,name
      ,application_id
      ,object_version_number
      ,application_retrieval_function
      ,application_update_process
      ,appl_validation_process
      ,application_period_function
      ,appl_dynamic_template_process
      ,extension_function1
      ,extension_function2
    from	hxc_time_recipients
    where	time_recipient_id = p_time_recipient_id
    for	update nowait;

Line: 216

  ,p_appl_update_process            in varchar2
  ,p_appl_validation_process        in varchar2
  ,p_appl_period_function           in varchar2
  ,p_appl_dyn_template_process      in varchar2
  ,p_extension_function1            in varchar2
  ,p_extension_function2            in varchar2
  ,p_application_id                 in number
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 238

  l_rec.application_update_process       := p_appl_update_process;