[Home] [Help]
387: c_currency_code VARCHAR2,
388: c_ledger_id NUMBER,
389: c_entity_id NUMBER) IS
390: SELECT 1
391: FROM fem_balances fb,
392: gcs_categories_b cb
393: WHERE fb.dataset_code = p_hier_dataset_code
394: AND fb.cal_period_id = c_cal_period_id
395: AND fb.source_system_code = c_source_system_code
1331:
1332: pl_text :=
1333: 'SELECT nvl(sum(nvl(fb.ytd_debit_balance_e, 0)),0), ' ||
1334: 'nvl(sum(nvl(fb.ytd_credit_balance_e, 0)),0)' || g_nl ||
1335: 'FROM FEM_BALANCES fb,' || g_nl ||
1336: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
1337: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
1338: 'WHERE fb.dataset_code = ' || p_hier_dataset_code || g_nl ||
1339: 'AND fb.created_by_object_id = ' || fb_object_id || g_nl ||
1384: 'decode(''' || p_eq_xlate_mode || ''', ''YTD'', nvl(min(ytd_debit_balance_e),0) + :re_delta_dr, 0), ' ||
1385: 'decode(''' || p_eq_xlate_mode || ''', ''YTD'', nvl(min(ytd_credit_balance_e),0) + :re_delta_cr, 0), ' ||
1386: 'nvl(min(ytd_debit_balance_e),0) + :re_delta_dr, ' ||
1387: 'nvl(min(ytd_credit_balance_e),0) + :re_delta_cr, 0, 0, 0, 0' || g_nl ||
1388: 'FROM FEM_BALANCES fb' || g_nl ||
1389: 'WHERE fb.dataset_code = ' || p_hier_dataset_code || g_nl ||
1390: 'AND fb.created_by_object_id = ' || fb_object_id || g_nl ||
1391: 'AND fb.cal_period_id = ' || p_prev_period_id || g_nl ||
1392: 'AND fb.source_system_code = ' || p_source_system_code || g_nl ||
1740: ' (xlat.ytd_debit - xlat.ytd_credit)/(func.ytd_debit - func.ytd_credit))' || g_nl ||
1741: 'FROM' || g_nl ||
1742: ' (SELECT nvl(sum(nvl(fb.ytd_debit_balance_e, 0)),0) ytd_debit, ' ||
1743: 'nvl(sum(nvl(fb.ytd_credit_balance_e, 0)),0) ytd_credit' || g_nl ||
1744: ' FROM FEM_BALANCES fb,' || g_nl ||
1745: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
1746: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
1747: ' WHERE fb.dataset_code = ' || p_hier_dataset_code || g_nl ||
1748: ' AND fb.cal_period_id = ' || p_cal_period_id || g_nl ||