APPS.FII_SETUP_VAL_C dependencies on FII_FINANCIAL_DIMENSIONS_V

Line 471: from fii_financial_dimensions_v

467: and a.period_year = year;
468:
469: CURSOR enabled_dim_cur IS
470: select dimension_name, dimension_short_name
471: from fii_financial_dimensions_v
472: where dbi_enabled_flag = 'Y';
473:
474: CURSOR fin_type_cur IS
475: select 'R'

Line 837: from fii_financial_dimensions_v

833: AND object_type = 'MATERIALIZED VIEW';
834:
835: CURSOR dim_enabled_cur1 IS
836: select rpad(dimension_name, 40), dimension_short_name, dbi_enabled_flag
837: from fii_financial_dimensions_v
838: where dimension_short_name in ('FII_LOB', 'GL_FII_FIN_ITEM')
839: order by (decode (dimension_short_name, 'FII_LOB', 1, 'GL_FII_FIN_ITEM', 2));
840:
841: CURSOR dim_enabled_cur2 IS

Line 843: from fii_financial_dimensions_v

839: order by (decode (dimension_short_name, 'FII_LOB', 1, 'GL_FII_FIN_ITEM', 2));
840:
841: CURSOR dim_enabled_cur2 IS
842: select rpad(dimension_name, 40), dimension_short_name, dbi_enabled_flag
843: from fii_financial_dimensions_v
844: where dimension_short_name in ('FII_COMPANIES', 'HRI_CL_ORGCC',
845: 'FII_USER_DEFINED_1', 'GL_FII_FIN_ITEM')
846: order by (decode (dimension_short_name,
847: 'FII_COMPANIES', 1,

Line 1577: from fii_financial_dimensions_v

1573: -- Validate if we have any UDD1 values that has not been mapped
1574: ----------------------------------------------------------------------
1575: select dbi_enabled_flag
1576: into l_udd_enabled_flag
1577: from fii_financial_dimensions_v
1578: where dimension_short_name = 'FII_USER_DEFINED_1';
1579:
1580: IF (l_udd_enabled_flag = 'Y') THEN
1581: fii_util.put_line(' ');

Line 1639: from fii_financial_dimensions_v

1635: -- Validate if we have any UDD2 values that has not been mapped
1636: ----------------------------------------------------------------------
1637: select dbi_enabled_flag
1638: into l_udd_enabled_flag
1639: from fii_financial_dimensions_v
1640: where dimension_short_name = 'FII_USER_DEFINED_2';
1641:
1642: IF (l_udd_enabled_flag = 'Y') THEN
1643: fii_util.put_line(' ');