APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on GL_SETS_OF_BOOKS

Line 1443: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;

1439: l_tax_received_tbl NUMERIC1_TBL;
1440:
1441: l_bal_seg_prompt_tbl ATTRIBUTE1_TBL;
1442:
1443: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
1444: l_period_from gl_period_statuses.period_name%type;
1445: l_period_to gl_period_statuses.period_name%type;
1446:
1447: --Bug 9031051

Line 2517: from gl_sets_of_books gl, ar_system_parameters ar

2513: -- get details for C_GL_ACTIVITY_DISP
2514: BEGIN
2515: /* select gl.set_of_books_id
2516: into l_set_of_books_id
2517: from gl_sets_of_books gl, ar_system_parameters ar
2518: where gl.set_of_books_id = ar.set_of_books_id;
2519: */
2520:
2521: -- Introduced for the bug#7638536 ---

Line 2614: L_CHART_OF_ACCOUNTS_ID gl_sets_of_books.chart_of_accounts_id%type;

2610: l_seg_name varchar2(1000);
2611: l_prompt varchar2(1000) := '';
2612: l_value_set_name varchar2(1000);
2613: L_SEG_NUM NUMBER;
2614: L_CHART_OF_ACCOUNTS_ID gl_sets_of_books.chart_of_accounts_id%type;
2615: L_BALANCING_SEGMENT varchar2(100);
2616: l_bool boolean;
2617: BEGIN
2618: -- get details C_BAL_SEGMENT_PROMPT

Line 2622: -- from gl_sets_of_books gl, ar_system_parameters ar

2618: -- get details C_BAL_SEGMENT_PROMPT
2619: select to_char(chart_of_accounts_id)
2620: into l_CHART_OF_ACCOUNTS_ID
2621: from gl_ledgers where ledger_id = P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID;
2622: -- from gl_sets_of_books gl, ar_system_parameters ar
2623: -- where gl.set_of_books_id = ar.set_of_books_id;
2624:
2625: IF ( g_level_statement>= g_current_runtime_level ) THEN
2626: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',