[Home] [Help]
93: l_status VARCHAR2(1) := null;
94: l_retcode varchar2(15) := 0; --Set to S: Success, E: Error, or W: Warning
95:
96: /*
97: --- Warn user of accounts without a finantial category type in fii_fin_cat_type_assgns---
98: -----------------------------------------------------------------------------------------
99: CURSOR miss_fin_type_cur IS
100: SELECT glv.concatenated_segments,
101: sob.name ledger_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
109: AND t.ledger_id = sob.set_of_books_id
110: AND t.code_combination_id = glv.code_combination_id
111: AND t.fin_category_id IS NOT NULL
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,
216: fii_gl_ccid_dimensions ccid,
217: fii_fin_cat_type_assgns fin
218: where ccid.code_combination_id = t.code_combination_id
219: and fin.fin_category_id = t.fin_category_id
220: and fin.fin_cat_type_code IN ('EXP','R')
221: group by t.plan_type_code_flag,
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
388: AND bal.code_combination_id = ccid.code_combination_id (+)
389: AND bal.ledger_id = slga.ledger_id