APPS.FV_FACTS2_DERIVE_BALANCES dependencies on FND_FLEX_VALUES_VL

Line 136: --* : fnd_flex_values_vl SELECT *--

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 *--
140: --* Logic : 1. Get all the FACTSII accounts from table fv_facts_ussgl_accounts *--

Line 145: --* : 3. Find all the child accounts using the tables fnd_flex_values_vl *--

141: --* : and select only those accounts from table fv_facts_attributes *--
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

Line 182: FROM fnd_flex_values_vl

178: c_flex_value_hi VARCHAR2
179: )
180: IS
181: SELECT flex_value account
182: FROM fnd_flex_values_vl
183: WHERE flex_value_set_id = c_flex_value_set_id
184: AND flex_value BETWEEN c_flex_value_low AND c_flex_value_hi;
185:
186: