APPS.FV_FACTS2_DERIVE_BALANCES dependencies on FV_FACTS_ATTRIBUTES

Line 137: --* : fv_facts_attributes SELECT *--

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

Line 141: --* : and select only those accounts from table fv_facts_attributes *--

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 *--
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 *--

Line 204: FROM fv_facts_attributes fa,

200: FOR account_rec IN (SELECT fsgl.ussgl_account,
201: fa.public_law_code,
202: fa.advance_flag,
203: fa.transfer_flag
204: FROM fv_facts_attributes fa,
205: fv_facts_ussgl_accounts fsgl
206: WHERE fa.set_of_books_id = p_ledger_id
207: AND fsgl.reporting_type in (2,3)
208: AND fsgl.ussgl_account = fa.ussgl_acct_number