APPS.PAY_SBF_BUS SQL Statements

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

Line: 21

  select pet.template_id
  from   pay_shadow_input_values siv
  ,      pay_shadow_element_types pset
  ,      pay_element_templates pet
  where  siv.input_value_id = p_input_value_id
  and    pset.element_type_id = siv.element_type_id
  and    pet.template_id = pset.template_id;

Line: 44

Procedure chk_non_updateable_args
  (p_rec     in     pay_sbf_shd.g_rec_type
  ) is
  --
  -- Cursor to disallow update if a core balance classification has been
  -- generated from this shadow balance classification.
  --
  cursor csr_disallow_update is
  select null
  from   pay_template_core_objects tco
  where  tco.core_object_type = pay_tco_shd.g_sbf_lookup_type
  and    tco.shadow_object_id = p_rec.balance_feed_id;

Line: 57

  l_proc  varchar2(72) := g_package||'chk_non_updateable_args';

Line: 81

  open csr_disallow_update;

Line: 82

  fetch csr_disallow_update into l_disallow;

Line: 83

  if csr_disallow_update%found then
    hr_utility.set_location(l_proc, 20);

Line: 85

    close csr_disallow_update;

Line: 89

  close csr_disallow_update;

Line: 109

End chk_non_updateable_args;

Line: 120

  select null
  from   pay_shadow_input_values siv
  where  siv.input_value_id = p_input_value_id;

Line: 167

  select null
  from   pay_shadow_balance_feeds sbf
  where  sbf.input_value_id = p_input_value_id
  and    nvl(sbf.balance_type_id, hr_api.g_number) = p_balance_type_id;

Line: 176

  select null
  from   pay_shadow_input_values  siv
  ,      pay_shadow_balance_types sbt
  where  siv.input_value_id = p_input_value_id
  and    sbt.balance_type_id = p_balance_type_id
  and    upper(siv.uom) = upper(sbt.balance_uom)
  and    sbt.template_id = p_template_id;

Line: 263

  select null
  from   pay_shadow_balance_feeds sbf
  where  sbf.input_value_id = p_input_value_id
  and    nvl(upper(sbf.balance_name), hr_api.g_varchar2) =
         upper(p_balance_name);

Line: 367

  select null
  from pay_template_exclusion_rules ter
  where ter.exclusion_rule_id = p_exclusion_rule_id
  and   ter.template_id = p_template_id;

Line: 403

Procedure chk_delete
  (p_balance_feed_id     in     number
  ) is
  --
  -- Cursors to check for rows referencing the balance classification.
  --
  cursor csr_core_objects is
  select null
  from   pay_template_core_objects tco
  where  tco.core_object_type = pay_tco_shd.g_sbf_lookup_type
  and    tco.shadow_object_id = p_balance_feed_id;

Line: 415

  l_proc  varchar2(72) := g_package||'chk_delete';

Line: 433

    fnd_message.set_name('PAY', 'PAY_50108_SBF_INVALID_DELETE');

Line: 438

End chk_delete;

Line: 442

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

Line: 490

End insert_validate;

Line: 495

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

Line: 505

  chk_non_updateable_args(p_rec);

Line: 543

End update_validate;

Line: 548

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

Line: 557

  chk_delete(p_rec.balance_feed_id);

Line: 560

End delete_validate;