APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on GL_PERIOD_STATUSES

Line 1444: l_period_from gl_period_statuses.period_name%type;

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
1448: l_reporting_code_tbl attribute2_tbl;

Line 1445: l_period_to gl_period_statuses.period_name%type;

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
1448: l_reporting_code_tbl attribute2_tbl;
1449: l_reporting_code_char_tbl ATTRIBUTE10_TBL;

Line 2560: from gl_period_statuses gl

2556: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
2557: END IF;
2558: select gl.period_name
2559: into l_period_from
2560: from gl_period_statuses gl
2561: --, ar_system_parameters ar
2562: where gl.start_date = P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW
2563: and gl.set_of_books_id = P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID
2564: --l_set_of_books_id

Line 2571: from gl_period_statuses gl

2567:
2568:
2569: select gl.period_name
2570: bulk collect into l_end_period_tbl
2571: from gl_period_statuses gl
2572: where gl.end_date >= trunc(P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH)
2573: and gl.set_of_books_id = P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID
2574: and gl.application_id = 222
2575: order by gl.end_date ;

Line 2580: from gl_period_statuses gl

2576:
2577:
2578: /* select gl.period_name
2579: into l_period_to
2580: from gl_period_statuses gl
2581: --, ar_system_parameters ar
2582: where gl.end_date >= P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH
2583: and gl.set_of_books_id = P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID
2584: ---l_set_of_books_id