APPS.FII_PSI_FUNDS_AVAIL_SUM_PKG dependencies on FII_FINANCIAL_DIMENSIONS

Line 127: FROM fii_financial_dimensions

123: END IF;
124:
125: /* Bug 5883351: Find out if user defined dimension 1 is enabled or not */
126: SELECT dbi_enabled_flag INTO l_ud1_enabled_flag
127: FROM fii_financial_dimensions
128: WHERE dimension_short_name = 'FII_USER_DEFINED_1';
129:
130: /*Remove join to fii_udd2_hierarchies if fud2 is disabled, or fud2 is all
131: and the viewby dimension is not fud2. */

Line 134: FROM fii_financial_dimensions

130: /*Remove join to fii_udd2_hierarchies if fud2 is disabled, or fud2 is all
131: and the viewby dimension is not fud2. */
132:
133: SELECT dbi_enabled_flag INTO l_enabled_flag
134: FROM fii_financial_dimensions
135: WHERE dimension_short_name = 'FII_USER_DEFINED_2';
136:
137: IF l_enabled_flag = 'N' OR (l_fud2_id = 'All'
138: AND l_view_by <> 'FII_USER_DEFINED+FII_USER_DEFINED_2')