APPS.IBE_BI_PMV_UTIL_PVT dependencies on IBE_BI_MSITEORG_MV

Line 59: from ibe_bi_msiteorg_mv b

55: SELECT COUNT(distinct f_curr.currency_code) new_count_number
56: INTO g_all_curr_count
57: FROM ibe_bi_currency_v f_curr
58: WHERE not exists (select b.org_id
59: from ibe_bi_msiteorg_mv b
60: where b.msite_id = f_Curr.msite_id
61: MINUS
62: select a.organization_id
63: from per_organization_list a

Line 82: from ibe_bi_msiteorg_mv b

78: FROM ibe_bi_currency_v f_curr
79: WHERE currency_code <> g_gp_currency
80: and currency_code <> g_gs_currency
81: and not exists (select b.org_id
82: from ibe_bi_msiteorg_mv b
83: where b.msite_id = f_Curr.msite_id
84: MINUS
85: select a.organization_id
86: from per_organization_list a