APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on GL_SETS_OF_BOOKS

Line 931: l_set_of_books_id apps.gl_sets_of_books.set_of_books_id%type;

927: l_org_id_tbl zx_extract_pkg.INTERNAL_ORGANIZATION_ID_TBL;
928:
929: l_bal_seg_prompt_tbl ATTRIBUTE1_TBL;
930:
931: l_set_of_books_id apps.gl_sets_of_books.set_of_books_id%type;
932: l_period_from apps.gl_period_statuses.period_name%type;
933: l_period_to apps.gl_period_statuses.period_name%type;
934:
935: BEGIN

Line 1238: from gl_sets_of_books gl, ar_system_parameters ar

1234: -- get details for C_GL_ACTIVITY_DISP
1235: BEGIN
1236: /* select gl.set_of_books_id
1237: into l_set_of_books_id
1238: from gl_sets_of_books gl, ar_system_parameters ar
1239: where gl.set_of_books_id = ar.set_of_books_id;
1240: */
1241:
1242: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 1295: L_CHART_OF_ACCOUNTS_ID apps.gl_sets_of_books.chart_of_accounts_id%type;

1291: l_seg_name varchar2(1000);
1292: l_prompt varchar2(1000) := '';
1293: l_value_set_name varchar2(1000);
1294: L_SEG_NUM NUMBER;
1295: L_CHART_OF_ACCOUNTS_ID apps.gl_sets_of_books.chart_of_accounts_id%type;
1296: L_BALANCING_SEGMENT varchar2(100);
1297: l_bool boolean;
1298: BEGIN
1299: -- get details C_BAL_SEGMENT_PROMPT

Line 1303: -- from gl_sets_of_books gl, ar_system_parameters ar

1299: -- get details C_BAL_SEGMENT_PROMPT
1300: select to_char(chart_of_accounts_id)
1301: into l_CHART_OF_ACCOUNTS_ID
1302: from gl_ledgers where ledger_id = P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID;
1303: -- from gl_sets_of_books gl, ar_system_parameters ar
1304: -- where gl.set_of_books_id = ar.set_of_books_id;
1305:
1306: IF ( g_level_statement>= g_current_runtime_level ) THEN
1307: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',