DBA Data[Home] [Help]

APPS.FII_BUDGET_INTERFACE_PKG dependencies on FII_FINANCIAL_DIMENSIONS

Line 141: FROM fnd_flex_values f, fnd_flex_values_tl t, fii_financial_dimensions ffd

137: IF X_User_Defined_Dim is not null THEN
138: BEGIN
139: SELECT f.flex_value_id
140: INTO l_user_defined_dim
141: FROM fnd_flex_values f, fnd_flex_values_tl t, fii_financial_dimensions ffd
142: WHERE flex_value_set_id in
143: (SELECT MASTER_VALUE_SET_ID id FROM fii_financial_dimensions
144: WHERE dimension_short_name = 'FII_USER_DEFINED_1'
145: UNION

Line 143: (SELECT MASTER_VALUE_SET_ID id FROM fii_financial_dimensions

139: SELECT f.flex_value_id
140: INTO l_user_defined_dim
141: FROM fnd_flex_values f, fnd_flex_values_tl t, fii_financial_dimensions ffd
142: WHERE flex_value_set_id in
143: (SELECT MASTER_VALUE_SET_ID id FROM fii_financial_dimensions
144: WHERE dimension_short_name = 'FII_USER_DEFINED_1'
145: UNION
146: SELECT map.flex_value_set_id1 id
147: FROM fii_dim_mapping_rules map, fii_slg_assignments sts, fii_source_ledger_groups slg,