APPS.BEN_CTK_SHD SQL Statements

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

Line: 61

    select
       group_per_in_ler_id
      ,task_id
      ,group_pl_id
      ,lf_evt_ocrd_dt
      ,status_cd
      ,access_cd
      ,task_last_update_date
      ,task_last_update_by
      ,object_version_number
    from        ben_cwb_person_tasks
    where       group_per_in_ler_id = p_group_per_in_ler_id
    and   task_id = p_task_id;

Line: 140

    select
       group_per_in_ler_id
      ,task_id
      ,group_pl_id
      ,lf_evt_ocrd_dt
      ,status_cd
      ,access_cd
      ,task_last_update_date
      ,task_last_update_by
      ,object_version_number
    from        ben_cwb_person_tasks
    where       group_per_in_ler_id = p_group_per_in_ler_id
    and   task_id = p_task_id
    for update nowait;

Line: 228

  ,p_task_last_update_date          in date
  ,p_task_last_update_by            in number
  ,p_object_version_number          in number
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 246

  l_rec.task_last_update_date            := p_task_last_update_date;

Line: 247

  l_rec.task_last_update_by              := p_task_last_update_by;