APPS.PER_BBA_BUS SQL Statements

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

Line: 27

    select inf.org_information14
      from hr_organization_information inf
         , per_bf_balance_amounts bba
     where bba.balance_amount_id = p_balance_amount_id
       and inf.organization_id   = bba.business_group_id
       and inf.org_information_context || '' = 'Business Group Information';

Line: 84

    select pbg.legislation_code
      from per_business_groups pbg
         , per_bf_balance_amounts bba
     where bba.balance_amount_id = p_balance_amount_id
       and pbg.business_group_id = bba.business_group_id;

Line: 346

Procedure chk_non_updateable_args(p_rec in per_bba_shd.g_rec_type) IS
--
  l_proc     varchar2(72) := g_package || 'check_non_updateable_args';

Line: 398

End chk_non_updateable_args;

Line: 426

  SELECT 1
  FROM PER_BF_PROCESSED_ASSIGNMENTS
  WHERE processed_assignment_id = p_processed_assignment_id;

Line: 481

  SELECT 1
  FROM per_bf_balance_types
  WHERE balance_type_id = p_balance_type_id
  AND business_group_id = p_business_group_id;

Line: 510

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

Line: 535

End insert_validate;

Line: 540

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

Line: 553

  chk_non_updateable_args(p_rec => p_rec);

Line: 561

End update_validate;

Line: 566

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

Line: 576

End delete_validate;