APPS.PAY_TCO_BUS SQL Statements

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

Line: 21

  select pet.business_group_id
  from   pay_element_templates pet
  where  pet.template_id = p_template_id;

Line: 40

Procedure chk_non_updateable_args
  (p_rec     in     pay_tco_shd.g_rec_type
  ) is
  l_proc  varchar2(72) := g_package||'chk_non_updateable_args';

Line: 100

End chk_non_updateable_args;

Line: 143

  select null
  from   pay_element_templates pet
  where  pet.template_id = p_template_id
  and    pet.template_type = 'U';

Line: 225

  select null
  from   pay_template_core_objects tco
  where  tco.shadow_object_id = p_shadow_object_id
  and    tco.core_object_type = p_core_object_type;

Line: 234

  select null
  from   pay_shadow_element_types pset
  where  pset.template_id = p_template_id
  and    pset.payroll_formula_id = p_shadow_object_id;

Line: 240

  select null
  from   pay_shadow_input_values psiv
  ,      pay_shadow_element_types pset
  where  pset.template_id = p_template_id
  and    pset.element_type_id = psiv.element_type_id
  and    psiv.formula_id = p_shadow_object_id;

Line: 248

  select null
  from   pay_shadow_balance_types sbt
  where  sbt.template_id = p_template_id
  and    sbt.balance_type_id = p_shadow_object_id;

Line: 254

  select null
  from   pay_shadow_balance_types sbt
  ,      pay_shadow_defined_balances sdb
  where  sbt.template_id = p_template_id
  and    sdb.balance_type_id = sbt.balance_type_id
  and    sdb.defined_balance_id = p_shadow_object_id;

Line: 262

  select null
  from   pay_shadow_element_types pset
  where  pset.template_id = p_template_id
  and    pset.element_type_id = p_shadow_object_id;

Line: 268

  select null
  from   pay_shadow_element_types pset
  ,      pay_shadow_sub_classi_rules scr
  where  pset.template_id = p_template_id
  and    scr.element_type_id = pset.element_type_id
  and    scr.sub_classification_rule_id = p_shadow_object_id;

Line: 276

  select null
  from   pay_shadow_balance_types sbt
  ,      pay_shadow_balance_classi sbc
  where  sbt.template_id = p_template_id
  and    sbc.balance_type_id = sbt.balance_type_id
  and    sbc.balance_classification_id = p_shadow_object_id;

Line: 284

  select null
  from   pay_shadow_element_types pset
  ,      pay_shadow_input_values siv
  where  pset.template_id = p_template_id
  and    siv.element_type_id = pset.element_type_id
  and    siv.input_value_id = p_shadow_object_id;

Line: 292

  select null
  from   pay_shadow_element_types pset
  ,      pay_shadow_input_values siv
  ,      pay_shadow_balance_feeds sbf
  where  pset.template_id = p_template_id
  and    siv.element_type_id = pset.element_type_id
  and    sbf.input_value_id = siv.input_value_id
  and    sbf.balance_feed_id = p_shadow_object_id;

Line: 302

  select null
  from   pay_shadow_element_types pset
  ,      pay_shadow_formula_rules sfr
  where  pset.template_id = p_template_id
  and    sfr.shadow_element_type_id = pset.element_type_id
  and    sfr.formula_result_rule_id = p_shadow_object_id;

Line: 310

  select null
  from   pay_shadow_element_types   pset
  ,      pay_shadow_iterative_rules sir
  where  pset.template_id      = p_template_id
  and    sir.element_type_id   = pset.element_type_id
  and    sir.iterative_rule_id = p_shadow_object_id;

Line: 318

  select null
  from   pay_shadow_element_types   pset
  ,      pay_shadow_ele_type_usages etu
  where  pset.template_id          = p_template_id
  and    etu.element_type_id       = pset.element_type_id
  and    etu.element_type_usage_id = p_shadow_object_id;

Line: 326

  select null
  from   pay_shadow_element_types     pset
  ,      pay_shadow_gu_bal_exclusions sgb
  where  pset.template_id        = p_template_id
  and    sgb.source_id           = pset.element_type_id
  and    sgb.grossup_balances_id = p_shadow_object_id;

Line: 334

  select null
  from   pay_shadow_balance_types    sbt
  ,      pay_shadow_defined_balances sdb
  ,      pay_shadow_bal_attributes   sba
  where  sba.balance_attribute_id = p_shadow_object_id
  and    sba.defined_balance_id   = sdb.defined_balance_id
  and    sdb.balance_type_id      = sbt.balance_type_id
  and    sbt.template_id          = p_template_id;

Line: 539

  select null
  from   pay_template_core_objects tco
  where  tco.core_object_id = p_core_object_id
  and    tco.core_object_type = p_core_object_type;

Line: 548

  select null
  from   ff_formulas_f ff
  where  ff.formula_id = p_core_object_id
  and    ff.business_group_id = p_business_group_id
  and    p_effective_date between
         ff.effective_start_date and ff.effective_end_date;

Line: 556

  select null
  from   pay_balance_types bt
  where  bt.balance_type_id = p_core_object_id
  and    bt.business_group_id = p_business_group_id;

Line: 562

  select null
  from   pay_defined_balances db
  where  db.defined_balance_id = p_core_object_id
  and    db.business_group_id = p_business_group_id;

Line: 568

  select null
  from   pay_element_types_f et
  where  et.element_type_id = p_core_object_id
  and    et.business_group_id = p_business_group_id
  and    p_effective_date between
         et.effective_start_date and et.effective_end_date;

Line: 576

  select null
  from   pay_sub_classification_rules_f scr
  where  scr.sub_classification_rule_id = p_core_object_id
  and    scr.business_group_id = p_business_group_id
  and    p_effective_date between
         scr.effective_start_date and scr.effective_end_date;

Line: 584

  select null
  from   pay_balance_classifications bc
  where  bc.balance_classification_id = p_core_object_id
  and    bc.business_group_id = p_business_group_id;

Line: 590

  select null
  from   pay_input_values_f iv
  where  iv.input_value_id = p_core_object_id
  and    iv.business_group_id = p_business_group_id
  and    p_effective_date between
         iv.effective_start_date and iv.effective_end_date;

Line: 598

  select null
  from   pay_balance_feeds_f bf
  where  bf.balance_feed_id = p_core_object_id
  and    bf.business_group_id = p_business_group_id
  and    p_effective_date between
         bf.effective_start_date and bf.effective_end_date;

Line: 606

  select null
  from   pay_formula_result_rules_f frr
  where  frr.formula_result_rule_id = p_core_object_id
  and    frr.business_group_id = p_business_group_id
  and    p_effective_date between
         frr.effective_start_date and frr.effective_end_date;

Line: 614

  select null
  from   pay_status_processing_rules_f spr
  where  spr.status_processing_rule_id = p_core_object_id
  and    spr.business_group_id = p_business_group_id
  and    p_effective_date between
         spr.effective_start_date and spr.effective_end_date;

Line: 622

  select null
  from   pay_iterative_rules_f  pir
  where  pir.iterative_rule_id     = p_core_object_id
  and    pir.business_group_id = p_business_group_id
  and    p_effective_date between
         pir.effective_start_date and pir.effective_end_date;

Line: 630

  select null
  from   pay_grossup_bal_exclusions gbe
  ,      pay_balance_types          pbt
  where  gbe.grossup_balances_id   = p_core_object_id
  and    gbe.balance_type_id       = pbt.balance_type_id
  and    pbt.business_group_id = p_business_group_id;

Line: 638

  select null
  from   pay_element_type_usages_f etu
  where  etu.business_group_id = p_business_group_id
  and    etu.element_type_usage_id = p_core_object_id
  and    p_effective_date between
         etu.effective_start_date and etu.effective_end_date;

Line: 646

  select null
  from   pay_balance_attributes ba
  where  ba.business_group_id = p_business_group_id
  and    ba.balance_attribute_id = p_core_object_id;

Line: 836

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

Line: 879

End insert_validate;

Line: 884

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

Line: 894

  chk_non_updateable_args(p_rec);

Line: 916

End update_validate;

Line: 921

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

Line: 931

End delete_validate;