APPS.PAY_DTE_SHD SQL Statements

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

Line: 63

    select
       datetracked_event_id
      ,event_group_id
      ,dated_table_id
      ,column_name
      ,update_type
      ,business_group_id
      ,legislation_code
      ,object_version_number
      ,proration_style
    from	pay_datetracked_events
    where	datetracked_event_id = p_datetracked_event_id;

Line: 137

    select
       datetracked_event_id
      ,event_group_id
      ,dated_table_id
      ,column_name
      ,update_type
      ,business_group_id
      ,legislation_code
      ,object_version_number
      ,proration_style
    from	pay_datetracked_events
    where	datetracked_event_id = p_datetracked_event_id
    for	update nowait;

Line: 202

  ,p_update_type                    in varchar2
  ,p_business_group_id              in number
  ,p_legislation_code               in varchar2
  ,p_object_version_number          in number
  ,p_proration_style                in varchar2 default null
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 220

  l_rec.update_type                      := p_update_type;