eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.FII_GL_BUDGET_EXTRACTION dependencies on FII_SLG_BUDGET_ASGNS

Line 143: --assignments table (fii_slg_budget_asgns) and the temp table (FII_GL_BUDGET_EXTRACT_T)

139:
140: --- Warn user of periods not translated to primary currency ---------------------------
141: -----------------------------------------------------------------------------------------
142: --The missing GL periods are found as the difference between records in the FDS
143: --assignments table (fii_slg_budget_asgns) and the temp table (FII_GL_BUDGET_EXTRACT_T)
144: -----------------------------------------------------------------------------------------
145: CURSOR miss_per_cur_prim IS
146: SELECT /*+ use_nl (setup) use_nl(sob) use_nl(per) use_nl(bud) */
147: sob.name ledger_name, bud.budget_name, per.period_name

Line 148: from fii_slg_budget_asgns setup,

144: -----------------------------------------------------------------------------------------
145: CURSOR miss_per_cur_prim IS
146: SELECT /*+ use_nl (setup) use_nl(sob) use_nl(per) use_nl(bud) */
147: sob.name ledger_name, bud.budget_name, per.period_name
148: from fii_slg_budget_asgns setup,
149: gl_periods per,
150: gl_ledgers_public_v sob,
151: gl_budgets_v bud
152: where setup.budget_version_id = bud.budget_version_id

Line 174: --assignments table (fii_slg_budget_asgns) and the temp table (FII_GL_BUDGET_EXTRACT_T)

170:
171: --- Warn user of periods not translated to secondary currency ---------------------------
172: -----------------------------------------------------------------------------------------
173: --The missing GL periods are found as the difference between records in the FDS
174: --assignments table (fii_slg_budget_asgns) and the temp table (FII_GL_BUDGET_EXTRACT_T)
175: -----------------------------------------------------------------------------------------
176: CURSOR miss_per_cur_sec IS
177: SELECT /*+ use_nl (setup) use_nl(sob) use_nl(per) use_nl(bud) */
178: sob.name ledger_name, bud.budget_name, per.period_name

Line 179: from fii_slg_budget_asgns setup,

175: -----------------------------------------------------------------------------------------
176: CURSOR miss_per_cur_sec IS
177: SELECT /*+ use_nl (setup) use_nl(sob) use_nl(per) use_nl(bud) */
178: sob.name ledger_name, bud.budget_name, per.period_name
179: from fii_slg_budget_asgns setup,
180: gl_periods per,
181: gl_ledgers_public_v sob,
182: gl_budgets_v bud
183: where setup.budget_version_id = bud.budget_version_id

Line 382: FII_SLG_BUDGET_ASGNS slga,

378: g_fii_user_id
379: FROM GL_BALANCES bal,
380: FII_GL_CCID_DIMENSIONS ccid,
381: FII_CCC_MGR_GT cccorg,
382: FII_SLG_BUDGET_ASGNS slga,
383: GL_PERIODS glper,
384: GL_LEDGERS_PUBLIC_V sob,
385: FII_FIN_CAT_TYPE_ASSGNS fincat
386: WHERE fincat.fin_category_id (+) = ccid.natural_account_id

Line 635: fii_slg_budget_asgns setup

631: FROM FII_GL_BUDGET_EXTRACT_T t,
632: FII_TIME_ENT_PERIOD period,
633: GL_PERIODS glper,
634: GL_LEDGERS_PUBLIC_V sob,
635: fii_slg_budget_asgns setup
636: WHERE t.period_name = glper.period_name
637: ANd sob.ledger_id = t.ledger_id
638: AND sob.period_set_name = glper.period_set_name
639: AND sob.accounted_period_type = glper.period_type