APPS.PER_PCL_SHD SQL Statements

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

Line: 62

    SELECT pce.cagr_entitlement_item_id,
	       pci.category_name,
		   pce.formula_criteria
	FROM   per_cagr_entitlements pce,
	       per_cagr_entitlement_items pci
	WHERE  pci.cagr_entitlement_item_id = pce.cagr_entitlement_item_id
	AND    pce.cagr_entitlement_id      = p_cagr_entitlement_id;

Line: 125

    SELECT cag.collective_agreement_id,
               cag.business_group_id
        FROM   per_cagr_entitlements pce,
               per_collective_agreements cag
        WHERE  cag.collective_agreement_id = pce.collective_agreement_id
        AND    pce.cagr_entitlement_id     = p_cagr_entitlement_id;

Line: 184

    SELECT flex_value_set_id
	FROM   per_cagr_entitlement_items cei
	WHERE  cei.cagr_entitlement_item_Id = P_cagr_entitlement_item_id
	AND    cei.flex_value_set_id IS NOT NULL;

Line: 263

    select
     cagr_entitlement_line_id
    ,cagr_entitlement_id
    ,mandatory
    ,value
    ,range_from
    ,range_to
    ,effective_start_date
    ,effective_end_date
    ,parent_spine_id
    ,step_id
    ,from_step_id
    ,to_step_id
    ,status
    ,oipl_id
    ,object_version_number
    ,grade_spine_id
    ,eligy_prfl_id
    from        per_cagr_entitlement_lines_f
    where       cagr_entitlement_line_id = p_cagr_entitlement_line_id
    and         p_effective_date
    between     effective_start_date and effective_end_date;

Line: 343

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

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

Line: 376

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

    select
     t.grade_spine_id
    ,t.step_id
    ,t.from_step_id
    ,t.to_step_id
    from   per_cagr_entitlement_lines_f t
    where  t.cagr_entitlement_line_id = p_base_key_value
    and    p_effective_date
    between t.effective_start_date and t.effective_end_date;

Line: 436

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

Line: 478

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

Line: 512

    select
     cagr_entitlement_line_id
    ,cagr_entitlement_id
    ,mandatory
    ,value
    ,range_from
    ,range_to
    ,effective_start_date
    ,effective_end_date
    ,parent_spine_id
    ,step_id
    ,from_step_id
    ,to_step_id
    ,status
    ,oipl_id
    ,object_version_number
    ,grade_spine_id
    ,eligy_prfl_id
    from    per_cagr_entitlement_lines_f
    where   cagr_entitlement_line_id = p_cagr_entitlement_line_id
    and     p_effective_date
    between effective_start_date and effective_end_date
    for update nowait;

Line: 565

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