APPS.PAY_RFI_SHD SQL Statements

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

Line: 58

    select
     report_type
    ,report_qualifier
    ,report_category
    ,user_entity_id
    ,effective_start_date
    ,effective_end_date
    ,archive_type
    ,updatable_flag
    ,display_sequence
    ,object_version_number
    ,report_format_item_id
    ,null
    from        pay_report_format_items_f
    where       report_format_item_id = p_report_format_item_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;

Line: 140

  ,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: 158

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

Line: 173

  ,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: 183

    select
     m.report_format_mapping_id
    from   pay_report_format_items_f t
          ,pay_report_format_mappings_f m
    where  t.report_format_item_id = p_base_key_value
    and    p_effective_date
           between t.effective_start_date and t.effective_end_date
    and    t.report_type = m.report_type
    and    t.report_qualifier = m.report_qualifier
    and    t.report_category = m.report_category
    and    p_effective_date
           between m.effective_start_date and m.effective_end_date;

Line: 221

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

Line: 263

  update  pay_report_format_items_f t
  set     t.effective_end_date    = p_new_effective_end_date
    ,     t.object_version_number = l_object_version_number
  where   t.report_format_item_id        = p_base_key_value
  and     p_effective_date
  between t.effective_start_date and t.effective_end_date;

Line: 302

    select
     report_type
    ,report_qualifier
    ,report_category
    ,user_entity_id
    ,effective_start_date
    ,effective_end_date
    ,archive_type
    ,updatable_flag
    ,display_sequence
    ,object_version_number
    ,report_format_item_id
    ,null
    from    pay_report_format_items_f
    where   report_format_item_id = p_report_format_item_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 350

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

Line: 484

       select distinct report_format_item_id
          from  pay_report_format_items_f
          where report_type = p_report_type
          and   report_qualifier = p_report_qualifier
          and   report_category  = p_report_category
          and   user_entity_id   = p_user_entity_id ;