APPS.FII_GL_BUDGET_EXTRACTION dependencies on GL_BUDGET_VERSIONS

Line 104: gl_budget_versions budv,

100: SELECT glv.concatenated_segments,
101: sob.name ledger_name,
102: budv.budget_name
103: FROM fii_gl_budget_extract_t t,
104: gl_budget_versions budv,
105: gl_sets_of_books sob,
106: gl_code_combinations_kfv glv,
107: fii_fin_cat_type_assgns fin
108: WHERE t.budget_version_id = budv.budget_version_id

Line 126: gl_budget_versions budv,

122: SELECT glv.concatenated_segments,
123: sob.name ledger_name,
124: budv.budget_name
125: FROM fii_gl_budget_extract_t t,
126: gl_budget_versions budv,
127: gl_sets_of_books sob,
128: gl_code_combinations_kfv glv,
129: fii_gl_ccid_dimensions ccid
130: WHERE t.budget_version_id = budv.budget_version_id

Line 163: from fii_gl_budget_extract_t t, gl_budget_versions budv,

159: --the last condition serves to avoid pulling in adjusting periods that match the end date of FDS budgets but are not defined in GL as part of the budgets
160: MINUS
161: SELECT /*+ use_hash(budv, t) parallel(t) */
162: sob.name ledger_name, budv.budget_name, t.period_name
163: from fii_gl_budget_extract_t t, gl_budget_versions budv,
164: gl_ledgers_public_v sob
165: where t.budget_version_id = budv.budget_version_id
166: and t.ledger_id = sob.ledger_id
167: and t.currency_code = g_prim_curr;

Line 194: from fii_gl_budget_extract_t t, gl_budget_versions budv,

190: --the last condition serves to avoid pulling in adjusting periods that match the end date of FDS budgets but are not defined in GL as part of the budgets
191: MINUS
192: SELECT /*+ use_hash(budv, t) parallel(t) */
193: sob.name ledger_name, budv.budget_name, t.period_name
194: from fii_gl_budget_extract_t t, gl_budget_versions budv,
195: gl_ledgers_public_v sob
196: where t.budget_version_id = budv.budget_version_id
197: and t.ledger_id = sob.ledger_id
198: and t.currency_code = g_sec_curr;

Line 211: GL_BUDGET_VERSIONS budv,

207: sob.name ledger_name,
208: budv.budget_name
209: FROM FII_GL_BUDGET_EXTRACT_T t,
210: GL_LEDGERS_PUBLIC_V sob,
211: GL_BUDGET_VERSIONS budv,
212: gl_code_combinations_kfv glv,
213: (select /*+ use_hash(fin,t,ccid) parallel(t) parallel(ccid) parallel(fin) pq_distribute(fin hash,hash) pq_distribute(ccid hash,hash)*/
214: t.code_combination_id, period_name
215: from FII_GL_BUDGET_EXTRACT_T t,