APPS.IRC_IAS_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id
      from per_business_groups pbg
         , per_all_assignments_f asg
      where pbg.business_group_id = asg.business_group_id
      and asg.assignment_id = p_assignment_id ;

Line: 86

    select pbg.legislation_code
      from per_business_groups_perf     pbg
         , per_all_assignments_f asg
         , irc_assignment_statuses ias
      where pbg.business_group_id = asg.business_group_id
      and asg.assignment_id = ias.assignment_id
      and ias.assignment_status_id = p_assignment_status_id ;

Line: 171

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

Line: 193

End chk_non_updateable_args;

Line: 228

  select 1
  from per_all_assignments_f
  where assignment_id = p_assignment_id
  and assignment_type = 'A';

Line: 234

  select 1
  from per_all_assignments_f paaf1
  where assignment_id = p_assignment_id
  and exists ( select null
                from per_all_assignments_f paaf2
               where paaf1.person_id = paaf2.person_id
                 and paaf1.vacancy_id = paaf2.vacancy_id
                 and paaf2.assignment_type = 'A');

Line: 326

  select 1
  from PER_ASSIGNMENT_STATUS_TYPES
  where ASSIGNMENT_STATUS_TYPE_ID = P_ASG_STATUS_TYPE_ID;

Line: 365

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

Line: 390

End insert_validate;

Line: 395

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

Line: 409

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 422

End update_validate;

Line: 427

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

Line: 439

End delete_validate;