21:
22: -- ------------------------------------
23: -- All Pre-build Query Variables
24: -- ------------------------------------
25: g_chart_of_accounts_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
26: g_fund_segment_name VARCHAR2(10);
27: --
28: -- ------------------------------------
29: -- Stored Global Variables
343: select currency_code,
344: chart_of_accounts_id
345: into g_currency_code,
346: g_chart_of_accounts_id
347: from gl_ledgers_public_v
348: where ledger_id = parm_set_of_books_id;
349: --Added for bug No. 1553099
350:
351: -- ----------------------------------------
568: -- Store SoB's Chart of Accounts Id
569: -- -------------------------------------
570: SELECT chart_of_accounts_id
571: INTO g_chart_of_accounts_id
572: FROM gl_ledgers_public_v
573: WHERE ledger_id = parm_set_of_books_id;
574: --
575: /* SELECT statement brought OUT NOCOPY of the LOOP as it does nto use any of the loop variables */
576: -- find the balance segment (fund) application_column_name