APPS.FII_GL_UTIL_PKG dependencies on FII_FINANCIAL_DIMENSIONS

Line 215: -- dimension is disabled, otherwise pick FROM fii_financial_dimensions table.

211:
212: /* When LOB chosen is All, we assign the top node LOB id to g_lob_id */
213:
214: -- Bug 4135136. Pick the top node id FROM pruned hierarchy table when the
215: -- dimension is disabled, otherwise pick FROM fii_financial_dimensions table.
216:
217: SELECT dbi_enabled_flag INTO l_lob_enabled_flag
218: FROM fii_financial_dimensions
219: WHERE dimension_short_name = 'FII_LOB';

Line 218: FROM fii_financial_dimensions

214: -- Bug 4135136. Pick the top node id FROM pruned hierarchy table when the
215: -- dimension is disabled, otherwise pick FROM fii_financial_dimensions table.
216:
217: SELECT dbi_enabled_flag INTO l_lob_enabled_flag
218: FROM fii_financial_dimensions
219: WHERE dimension_short_name = 'FII_LOB';
220:
221: If l_lob_enabled_flag = 'N' THEN
222: IF g_lob_id IS NULL OR g_lob_id = 'ALL' THEN

Line 233: FROM fii_financial_dimensions

229: ELSE
230: IF g_lob_id IS NULL OR g_lob_id = 'ALL' THEN
231:
232: SELECT dbi_hier_top_node_id INTO g_lob_id
233: FROM fii_financial_dimensions
234: WHERE dimension_short_name = 'FII_LOB';
235:
236: g_lob_is_top_node := 'Y';
237: END IF;