APPS.AMS_OP_UTILITY_PVT dependencies on IBE_MSITES_B

Line 36: from ibe_msites_b

32: select mss.level_number
33: from ibe_dsp_msite_sct_sects mss
34: where mss.child_section_id=
35: (select msite_root_section_id
36: from ibe_msites_b
37: where msite_id=p_mini_site_id)
38: and mss.mini_site_id =
39: (select msite_id
40: from ibe_msites_b

Line 40: from ibe_msites_b

36: from ibe_msites_b
37: where msite_id=p_mini_site_id)
38: and mss.mini_site_id =
39: (select msite_id
40: from ibe_msites_b
41: where master_msite_flag='Y');
42:
43: l_level_number number;
44: BEGIN