APPS.PER_CEI_BUS SQL Statements

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

Line: 27

    select pbg.security_group_id
      from per_business_groups pbg
         , per_cagr_entitlement_items cei
     where cei.cagr_entitlement_item_id = p_cagr_entitlement_item_id
       and pbg.business_group_id = cei.business_group_id;

Line: 87

    select pbg.legislation_code
      from per_business_groups pbg
         , per_cagr_entitlement_items cei
     where cei.cagr_entitlement_item_id = p_cagr_entitlement_item_id
       and pbg.business_group_id = cei.business_group_id;

Line: 175

Procedure chk_non_updateable_args
  (p_effective_date               in date
  ,p_rec in per_cei_shd.g_rec_type
  ) IS
  --
  l_proc        varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 338

End chk_non_updateable_args;

Line: 382

  SELECT cei.item_name
  FROM   per_cagr_entitlement_items cei
  WHERE  cei.item_name         = p_item_name
  AND    cei.category_name     = p_category_name
  AND    cei.business_group_id IS NULL
  AND    cei.legislation_code  IS NULL;

Line: 390

  SELECT cei.item_name
  FROM   per_cagr_entitlement_items cei
  WHERE  cei.item_name         = p_item_name
  AND    cei.category_name     = p_category_name
  AND    cei.business_group_id IS NULL
  AND    cei.legislation_code  = p_legislation_code;

Line: 398

  SELECT cei.item_name
  FROM   per_cagr_entitlement_items cei
  WHERE  cei.item_name         = p_item_name
  AND    cei.category_name     = p_category_name
  AND    cei.business_group_id = p_business_group_id
  AND    cei.legislation_code  = p_legislation_code;

Line: 521

    SELECT territory_code
    FROM   fnd_territories ft
    WHERE  ft.territory_code = p_legislation_code;

Line: 694

    SELECT column_type
	  FROM per_cagr_api_parameters p
	 WHERE p.cagr_api_param_id = p_cagr_api_param_id
	  AND  p.column_type = p_column_type;

Line: 833

    SELECT column_size
	  FROM per_cagr_api_parameters p
	 WHERE p.cagr_api_param_id = p_cagr_api_param_id
	  AND  p.column_size = p_column_size;

Line: 941

    SELECT cagr_api_id
    FROM   per_cagr_apis pca
    WHERE  pca.cagr_api_id = p_cagr_api_id;

Line: 1056

    SELECT cagr_api_param_id
    FROM   per_cagr_api_parameters cap
    WHERE  cap.cagr_api_param_id = p_cagr_api_param_id
    AND    cap.cagr_api_id       = p_cagr_api_id;

Line: 1248

    SELECT p.uom_lookup,
	       p.default_uom
    FROM   per_cagr_api_parameters p
    WHERE  p.cagr_api_param_id = p_cagr_api_param_id;

Line: 1254

    SELECT piv.uom
	  FROM pay_input_values_f piv
	 WHERE piv.input_value_id = p_input_value_id
	   AND p_effective_date BETWEEN piv.effective_start_date
	                           AND piv.effective_end_date;

Line: 1539

    SELECT multiple_entries_allowed_flag
    FROM   pay_element_types_f p --pay_element_types_x p
    WHERE  ((p.business_group_id  = p_business_group_id) OR
	        (p.business_group_id IS NULL))
    AND    ((p.legislation_code   = p_legislation_code) OR
	        (p.legislation_code   IS NULL))
    AND    p.element_type_id    = p_element_type_id
    AND    p_effective_date between p.effective_start_date and p.effective_end_date;

Line: 1787

   SELECT pce.cagr_entitlement_item_id
    FROM   per_cagr_entitlement_items pce
    WHERE  pce.category_name      = 'ASG'
	AND    ((p_cagr_entitlement_item_id IS NULL) OR
	        (pce.cagr_entitlement_item_id <> p_cagr_entitlement_item_id))
    AND    ((pce.business_group_id IS NULL  AND
	         pce.legislation_code  IS NULL) OR
	        (pce.business_group_id IS NULL  AND
			 pce.legislation_code  = p_legislation_code) OR
			(pce.business_group_id = p_business_group_id AND
			 pce.legislation_code  = p_legislation_code))
    AND    pce.cagr_api_id        = p_cagr_api_id
    AND    pce.cagr_api_param_id  = p_cagr_api_param_id;

Line: 1802

    SELECT pce.cagr_entitlement_item_id
    FROM   per_cagr_entitlement_items pce
    WHERE  ((p_cagr_entitlement_item_id IS NULL) OR
	        (pce.cagr_entitlement_item_id <> p_cagr_entitlement_item_id))
	AND    ((pce.business_group_id IS NULL  AND
	         pce.legislation_code  IS NULL) OR
	        (pce.business_group_id IS NULL  AND
			 pce.legislation_code  = p_legislation_code) OR
			(pce.business_group_id = p_business_group_id AND
			 pce.legislation_code  = p_legislation_code))
    AND    pce.element_type_id = p_element_type_id
    AND    pce.input_value_id  = p_input_value_id;

Line: 1826

	-- If the item is being inserted or the api or parameter
	-- have been changed (thus updating) then check to see if
	-- if the entitlement item is unique.
	--
	IF ( (p_cagr_entitlement_item_id IS NULL) OR
         ((p_cagr_entitlement_item_id IS NOT NULL) AND
          ((per_cei_shd.g_old_rec.cagr_api_id  <> p_cagr_api_id) OR
		   (per_cei_shd.g_old_rec.cagr_api_param_id  <> p_cagr_api_param_id)
		  )
		 )
	    ) THEN
	  --
      hr_utility.set_location(l_proc,20);

Line: 1956

    SELECT pat.element_type_id
    FROM   pay_element_types_f pat
    WHERE  pat.element_type_id = p_element_type_id
	AND    ( ( pat.business_group_id IS NULL AND
	           pat.legislation_code  IS NULL) OR
	         ( pat.business_group_id IS NULL AND
			   pat.legislation_code  = p_legislation_code) OR
			 ( pat.business_group_id = p_business_group_id AND
			   pat.legislation_code  = p_legislation_code) OR
			 ( pat.business_group_id = p_business_group_id AND
			   pat.legislation_code  IS NULL)
		   )
    AND    p_effective_date BETWEEN pat.effective_start_date
                                AND pat.effective_end_date;

Line: 2106

    SELECT piv.input_value_id
    FROM   pay_input_values_f piv
    WHERE  piv.input_value_id = p_input_value_id
    AND    piv.element_type_id = p_element_type_id
    AND    p_effective_date BETWEEN piv.effective_start_date
                                AND piv.effective_end_date;

Line: 2240

  SELECT flex_value_set_id
  FROM   fnd_flex_value_sets F
  WHERE  f.flex_value_set_id = p_flex_value_set_id
  AND    ((f.flex_value_set_name LIKE 'CAGR%') AND
          ((f.flex_value_set_name NOT LIKE 'CAGR_BR_%') AND
										 (f.flex_value_set_name <> 'CAGR_EMPLOYMENT_CATEGORY')))
  AND    f.validation_type = 'F';

Line: 2332

  SELECT flex_value_set_id
  FROM   fnd_flex_value_sets F
  WHERE  f.flex_value_set_id = p_ben_rule_value_set_id
  AND    f.flex_value_set_name like 'CAGR_BR_%'
  AND    f.validation_type = 'F';

Line: 2387

Procedure insert_validate
  (p_effective_date               in     date
  ,p_rec                          in out nocopy per_cei_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 2550

END insert_validate;

Line: 2555

Procedure update_validate
  (p_effective_date               in     date
  ,p_rec                          in out nocopy per_cei_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 2577

  chk_non_updateable_args
    (p_effective_date => p_effective_date
    ,p_rec            => p_rec);

Line: 2723

END update_validate;

Line: 2728

Procedure delete_validate
  (p_rec                          in per_cei_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 2743

End delete_validate;