DBA Data[Home] [Help]

APPS.PAY_ETP_SHD_ND SQL Statements

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

Line: 133

    select
     element_type_id
    ,effective_start_date
    ,effective_end_date
    ,business_group_id
    ,legislation_code
    ,formula_id
    ,input_currency_code
    ,output_currency_code
    ,classification_id
    ,benefit_classification_id
    ,additional_entry_allowed_flag
    ,adjustment_only_flag
    ,closed_for_entry_flag
    ,element_name
    ,indirect_only_flag
    ,multiple_entries_allowed_flag
    ,multiply_value_flag
    ,post_termination_rule
    ,process_in_run_flag
    ,processing_priority
    ,processing_type
    ,standard_link_flag
    ,comment_id
    ,null
    ,description
    ,legislation_subgroup
    ,qualifying_age
    ,qualifying_length_of_service
    ,qualifying_units
    ,reporting_name
    ,attribute_category
    ,attribute1
    ,attribute2
    ,attribute3
    ,attribute4
    ,attribute5
    ,attribute6
    ,attribute7
    ,attribute8
    ,attribute9
    ,attribute10
    ,attribute11
    ,attribute12
    ,attribute13
    ,attribute14
    ,attribute15
    ,attribute16
    ,attribute17
    ,attribute18
    ,attribute19
    ,attribute20
    ,element_information_category
    ,element_information1
    ,element_information2
    ,element_information3
    ,element_information4
    ,element_information5
    ,element_information6
    ,element_information7
    ,element_information8
    ,element_information9
    ,element_information10
    ,element_information11
    ,element_information12
    ,element_information13
    ,element_information14
    ,element_information15
    ,element_information16
    ,element_information17
    ,element_information18
    ,element_information19
    ,element_information20
    ,third_party_pay_only_flag
    ,object_version_number
    ,iterative_flag
    ,iterative_formula_id
    ,iterative_priority
    ,creator_type
    ,retro_summ_ele_id
    ,grossup_flag
    ,process_mode
    ,advance_indicator
    ,advance_payable
    ,advance_deduction
    ,process_advance_entry
    ,proration_group_id
    ,proration_formula_id
    ,recalc_event_group_id
    ,once_each_period_flag
    ,time_definition_type
    ,time_definition_id
    from        pay_element_types_f
    where       element_type_id = p_element_type_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;
Line: 287

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

    ,p_update                => p_update
    ,p_update_override       => p_update_override
    ,p_update_change_insert  => p_update_change_insert
    );
Line: 320

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

   ,p_delete                        => p_delete
   ,p_future_change                 => p_future_change
   ,p_delete_next_change            => p_delete_next_change
   );
Line: 381

  update  pay_element_types_f t
  set     t.effective_end_date    = p_new_effective_end_date
    ,     t.object_version_number = l_object_version_number
  where   t.element_type_id        = p_base_key_value
  and     p_effective_date
  between t.effective_start_date and t.effective_end_date;
Line: 420

    select
     element_type_id
    ,effective_start_date
    ,effective_end_date
    ,business_group_id
    ,legislation_code
    ,formula_id
    ,input_currency_code
    ,output_currency_code
    ,classification_id
    ,benefit_classification_id
    ,additional_entry_allowed_flag
    ,adjustment_only_flag
    ,closed_for_entry_flag
    ,element_name
    ,indirect_only_flag
    ,multiple_entries_allowed_flag
    ,multiply_value_flag
    ,post_termination_rule
    ,process_in_run_flag
    ,processing_priority
    ,processing_type
    ,standard_link_flag
    ,comment_id
    ,null
    ,description
    ,legislation_subgroup
    ,qualifying_age
    ,qualifying_length_of_service
    ,qualifying_units
    ,reporting_name
    ,attribute_category
    ,attribute1
    ,attribute2
    ,attribute3
    ,attribute4
    ,attribute5
    ,attribute6
    ,attribute7
    ,attribute8
    ,attribute9
    ,attribute10
    ,attribute11
    ,attribute12
    ,attribute13
    ,attribute14
    ,attribute15
    ,attribute16
    ,attribute17
    ,attribute18
    ,attribute19
    ,attribute20
    ,element_information_category
    ,element_information1
    ,element_information2
    ,element_information3
    ,element_information4
    ,element_information5
    ,element_information6
    ,element_information7
    ,element_information8
    ,element_information9
    ,element_information10
    ,element_information11
    ,element_information12
    ,element_information13
    ,element_information14
    ,element_information15
    ,element_information16
    ,element_information17
    ,element_information18
    ,element_information19
    ,element_information20
    ,third_party_pay_only_flag
    ,object_version_number
    ,iterative_flag
    ,iterative_formula_id
    ,iterative_priority
    ,creator_type
    ,retro_summ_ele_id
    ,grossup_flag
    ,process_mode
    ,advance_indicator
    ,advance_payable
    ,advance_deduction
    ,process_advance_entry
    ,proration_group_id
    ,proration_formula_id
    ,recalc_event_group_id
    ,once_each_period_flag
    ,time_definition_type
    ,time_definition_id
    from    pay_element_types_f
    where   element_type_id = p_element_type_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;
Line: 521

    select hc.comment_text
    from   hr_comments hc
    where  hc.comment_id = pay_etp_shd_nd.g_old_rec.comment_id;
Line: 552

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

        (p_datetrack_mode = hr_api.g_update             or
         p_datetrack_mode = hr_api.g_correction         or
         p_datetrack_mode = hr_api.g_update_override    or
         p_datetrack_mode = hr_api.g_update_change_insert)) then
       Open C_Sel3;