APPS.OTA_RUD_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups_perf pbg
         , ota_resource_usages rud
         , ota_offerings off
     where rud.resource_usage_id = p_resource_usage_id
      and rud.offering_id = off.offering_id
      and pbg.business_group_id = off.business_group_id;

Line: 101

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , ota_resource_usages rud
         , ota_suppliable_resources tsr
     where rud.resource_usage_id = p_resource_usage_id
      and rud.supplied_resource_id = tsr.supplied_Resource_id
      and pbg.business_group_id = tsr.business_group_id;

Line: 180

    select 'No'
      from ota_resource_usages                  rud
      where rud.supplied_resource_id          = p_supplied_resource_id
        and rud.offering_id           = p_offering_id;

Line: 244

	select
	   off.start_date
	  ,off.end_date
	from
	  ota_offerings  off
	where
	  off.offering_id = p_offering_id;

Line: 304

    select tsr.start_date,
           tsr.end_date
      from ota_suppliable_resources		tsr
      where tsr.supplied_resource_id	      =	p_supplied_resource_id;

Line: 361

	select 'YES'
	  from ota_suppliable_resources		tsr,
	       ota_offerings            	off
	    where tsr.supplied_resource_id    =	p_supplied_resource_id
	    and off.offering_id	              =	p_offering_id
	    and tsr.business_group_id	      =	off.business_group_id;

Line: 421

    select
      tsr.resource_type
    from
      ota_suppliable_resources tsr
    where
      tsr.supplied_resource_id = p_supplied_resource_id;

Line: 536

    select resource_type
    from ota_suppliable_resources
    where supplied_resource_id = p_rec.supplied_resource_id;

Line: 791

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

Line: 816

End chk_non_updateable_args;

Line: 821

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

Line: 846

End insert_validate;

Line: 851

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

Line: 875

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

Line: 884

End update_validate;

Line: 889

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

Line: 901

End delete_validate;