APPS.PER_CPA_BUS SQL Statements

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

Line: 32

    select pbg.security_group_id
      from per_business_groups pbg
         , per_cagr_api_parameters cpa
     where cpa.cagr_api_param_id = p_cagr_api_param_id;

Line: 96

    select pbg.legislation_code
      from per_business_groups     pbg
         , per_cagr_api_parameters cpa
     where cpa.cagr_api_param_id = p_cagr_api_param_id;

Line: 195

    SELECT null
    FROM   per_cagr_apis per
    WHERE  per.cagr_api_id = p_cagr_api_id;

Line: 280

    SELECT display_name
    FROM   per_cagr_api_parameters cpa
    WHERE  display_name = p_display_name
    AND    cagr_api_id  = p_cagr_api_id
    AND    ( (cagr_api_param_id <> p_cagr_api_param_id) OR
	         (p_cagr_api_param_id IS NULL));

Line: 377

    SELECT parameter_name
    FROM   per_cagr_api_parameters cpa
    WHERE  parameter_name = p_parameter_name
    AND    cagr_api_id  = p_cagr_api_id
    AND    ((cagr_api_param_id <> p_cagr_api_param_id) OR
	        (p_cagr_api_param_id IS NULL));

Line: 682

    SELECT cap.uom_parameter
    FROM   per_cagr_api_parameters cap
    WHERE  cap.cagr_api_id     = p_cagr_api_id
    AND    cap.uom_parameter = p_uom_parameter
	AND    ((cap.cagr_api_param_id <> p_cagr_api_param_id) OR
	        (p_cagr_api_param_id IS NULL));

Line: 769

    SELECT hl.lookup_type
    FROM   hr_standard_lookups hl
    WHERE  lookup_type = p_uom_lookup
    AND    p_effective_date BETWEEN NVL(hl.start_date_active,hr_general.start_of_time)
                            AND     NVL(hl.end_date_active,hr_general.end_of_time);

Line: 962

    SELECT cei.item_name
    FROM   per_cagr_entitlement_items cei
    WHERE  cei.cagr_api_param_id = p_cagr_api_param_id;

Line: 1022

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

Line: 1077

End chk_non_updateable_args;

Line: 1082

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

Line: 1177

End insert_validate;

Line: 1182

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

Line: 1194

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

Line: 1269

End update_validate;

Line: 1274

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

Line: 1289

End delete_validate;