APPS.PER_ABV_SHD SQL Statements

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

Line: 40

        ,p_program_update_date             date
        ,p_effective_start_date            date
        ,p_effective_end_date              date
        ,p_object_version_number           number
        ) Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 63

l_rec.program_update_date        := p_program_update_date;

Line: 124

    select
     assignment_budget_value_id
    ,business_group_id
    ,assignment_id
    ,unit
    ,value
    ,request_id
    ,program_application_id
    ,program_id
    ,program_update_date
    ,effective_start_date
    ,effective_end_date
    ,object_version_number
    from	per_assignment_budget_values_f
    where	assignment_budget_value_id = p_assignment_budget_value_id
    and		p_effective_date
    between	effective_start_date and effective_end_date;

Line: 197

  ,p_update                 out nocopy boolean
  ,p_update_override        out nocopy boolean
  ,p_update_change_insert   out nocopy boolean
  ) is
--
  l_proc 	varchar2(72) := g_package||'find_dt_upd_modes';

Line: 215

    ,p_update                => p_update
    ,p_update_override       => p_update_override
    ,p_update_change_insert  => p_update_change_insert
    );

Line: 230

  ,p_delete                out nocopy boolean
  ,p_future_change         out nocopy boolean
  ,p_delete_next_change    out nocopy boolean
  ) is
  --
  l_proc 		varchar2(72) 	:= g_package||'find_dt_del_modes';

Line: 240

    select
     t.assignment_id
    from   per_assignment_budget_values_f t
    where  t.assignment_budget_value_id = p_base_key_value
    and    p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 272

   ,p_delete                        => p_delete
   ,p_future_change                 => p_future_change
   ,p_delete_next_change            => p_delete_next_change
   );

Line: 314

  update  per_assignment_budget_values_f t
  set     t.effective_end_date    = p_new_effective_end_date
  where   t.assignment_budget_value_id        = p_base_key_value
  and     p_effective_date
  between t.effective_start_date and t.effective_end_date;

Line: 348

    select
     assignment_budget_value_id
    ,business_group_id
    ,assignment_id
    ,unit
    ,value
    ,request_id
    ,program_application_id
    ,program_id
    ,program_update_date
    ,effective_start_date
    ,effective_end_date
    ,object_version_number
    from    per_assignment_budget_values_f
    where   assignment_budget_value_id = p_assignment_budget_value_id
    and	    p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 396

  If (p_datetrack_mode <> hr_api.g_insert) then
    --
    -- We must select and lock the current row.
    --
    Open  C_Sel1;

Line: 480

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

Line: 501

  l_rec.program_update_date              := p_program_update_date;