APPS.FII_USER_SEC_OPTIMIZER dependencies on FII_FINANCIAL_DIMENSIONS

Line 72: g_phase := 'Selecting top nodes for company and cost center dimensions from fii_financial_dimensions.';

68: fii_util.write_log('Error in fii_util.truncate_table(''FII_COST_CENTER_GRANTS'', ''FII'', l_retcode)');
69: raise FIIUSECB_fatal_err;
70: END IF;
71:
72: g_phase := 'Selecting top nodes for company and cost center dimensions from fii_financial_dimensions.';
73:
74: select dbi_hier_top_node_id into l_company_top_node_id from fii_financial_dimensions where dimension_short_name='FII_COMPANIES';
75: select dbi_hier_top_node_id into l_cost_ctr_top_node_id from fii_financial_dimensions where dimension_short_name='HRI_CL_ORGCC';
76:

Line 74: select dbi_hier_top_node_id into l_company_top_node_id from fii_financial_dimensions where dimension_short_name='FII_COMPANIES';

70: END IF;
71:
72: g_phase := 'Selecting top nodes for company and cost center dimensions from fii_financial_dimensions.';
73:
74: select dbi_hier_top_node_id into l_company_top_node_id from fii_financial_dimensions where dimension_short_name='FII_COMPANIES';
75: select dbi_hier_top_node_id into l_cost_ctr_top_node_id from fii_financial_dimensions where dimension_short_name='HRI_CL_ORGCC';
76:
77: IF (l_company_top_node_id is null) or (l_cost_ctr_top_node_id is null) THEN
78: fii_util.write_log('Error: Top node for the company or cost center dimension is not assigned.');

Line 75: select dbi_hier_top_node_id into l_cost_ctr_top_node_id from fii_financial_dimensions where dimension_short_name='HRI_CL_ORGCC';

71:
72: g_phase := 'Selecting top nodes for company and cost center dimensions from fii_financial_dimensions.';
73:
74: select dbi_hier_top_node_id into l_company_top_node_id from fii_financial_dimensions where dimension_short_name='FII_COMPANIES';
75: select dbi_hier_top_node_id into l_cost_ctr_top_node_id from fii_financial_dimensions where dimension_short_name='HRI_CL_ORGCC';
76:
77: IF (l_company_top_node_id is null) or (l_cost_ctr_top_node_id is null) THEN
78: fii_util.write_log('Error: Top node for the company or cost center dimension is not assigned.');
79: raise FIIUSECB_fatal_err;