APPS.IBE_BI_PMV_UTIL_PVT dependencies on IBE_BI_CURRENCY_V

Line 57: FROM ibe_bi_currency_v f_curr

53: g_userid := fnd_global.user_id;
54:
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

Line 78: FROM ibe_bi_currency_v f_curr

74: IF g_all_curr_code IS NULL or fnd_global.user_id <> g_userid THEN
75: g_userid := fnd_global.user_id;
76: select distinct currency_code
77: into g_all_curr_code
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

Line 104: FROM ibe_bi_currency_v

100: l_count := g_msite_curr_count_table(l_msite_id);
101: ELSE
102: SELECT count(distinct currency_code) count_number
103: INTO g_msite_curr_count_table(l_msite_id)
104: FROM ibe_bi_currency_v
105: WHERE msite_id = l_msite_id;
106:
107: l_count := g_msite_curr_count_table(l_msite_id);
108: END IF;

Line 119: FROM ibe_bi_currency_v

115: x_out_var := g_msite_curr_table(l_msite_id);
116: ELSE
117: select currency_code
118: into g_msite_curr_table(l_msite_id)
119: FROM ibe_bi_currency_v
120: WHERE msite_id = to_number(l_MSITE_ID)
121: and currency_code <> g_gp_currency
122: and currency_code <> g_gs_currency;
123: x_out_var := g_msite_curr_table(l_msite_id);