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.

APPS.FII_GL_BUDGET_EXTRACTION dependencies on GL_PERIODS

Line 142: --The missing GL periods are found as the difference between records in the FDS

138: */
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) */

Line 149: gl_periods per,

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
153: and sob.ledger_id = setup.ledger_id

Line 173: --The missing GL periods are found as the difference between records in the FDS

169:
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) */

Line 180: gl_periods per,

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
184: and sob.ledger_id = setup.ledger_id

Line 383: GL_PERIODS glper,

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
387: AND (fincat.fin_cat_type_code IN ('EXP','R') OR fincat.fin_cat_type_code IS NULL) -- if NULL then amounts will be both 0

Line 633: GL_PERIODS glper,

629: g_fii_user_id,
630: g_fii_login_id
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