DBA Data[Home] [Help]

APPS.AMS_OP_UTILITY_PVT SQL Statements

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

Line: 32

  select mss.level_number
  from ibe_dsp_msite_sct_sects mss
  where mss.child_section_id=
     (select msite_root_section_id
     from ibe_msites_b
     where msite_id=p_mini_site_id)
     and mss.mini_site_id =
	(select msite_id
         from ibe_msites_b
	 where master_msite_flag='Y');