APPS.FV_FACTS2_DERIVE_BALANCES dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 135: --* Tables Used : fnd_flex_value_hierarchies SELECT *--

131: --* : g_SUCCESS *--
132: --* Called from : derive_balances *--
133: --* Calls : fv_utility.debug_mesg *--
134: --* : fv_utility.log_mesg *--
135: --* Tables Used : fnd_flex_value_hierarchies SELECT *--
136: --* : fnd_flex_values_vl SELECT *--
137: --* : fv_facts_attributes SELECT *--
138: --* : fv_facts_ussgl_accounts SELECT *--
139: --* : fv_factsii_accounts_gt INSERT *--

Line 146: --* : and fnd_flex_value_hierarchies and insert those too into the *--

142: --* : where the following attributes are set to Y. public_law_code, *--
143: --* : advance_flag and transfer_flag *--
144: --* : 2. Insert that account into table fv_factsii_accounts_gt *--
145: --* : 3. Find all the child accounts using the tables fnd_flex_values_vl *--
146: --* : and fnd_flex_value_hierarchies and insert those too into the *--
147: --* : temporary table fv_factsii_accounts_gt *--
148: --****************************************************************************************--
149: PROCEDURE explode_accounts
150: (

Line 169: FROM fnd_flex_value_hierarchies

165: )
166: IS
167: SELECT child_flex_value_low,
168: child_flex_value_high
169: FROM fnd_flex_value_hierarchies
170: WHERE parent_flex_value = c_account
171: AND flex_value_set_id = c_flex_value_set_id;
172:
173: