APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on GL_PERIOD_STATUSES

Line 932: l_period_from apps.gl_period_statuses.period_name%type;

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
936:

Line 933: l_period_to apps.gl_period_statuses.period_name%type;

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
936:
937: -- IF PG_DEBUG = 'Y' THEN

Line 1250: from gl_period_statuses gl

1246: 'P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH : '||P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH);
1247: END IF;
1248: select gl.period_name
1249: into l_period_from
1250: from gl_period_statuses gl
1251: --, ar_system_parameters ar
1252: where gl.start_date = P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW
1253: and gl.set_of_books_id = P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID
1254: --l_set_of_books_id

Line 1260: from gl_period_statuses gl

1256: and rownum = 1;
1257:
1258: select gl.period_name
1259: into l_period_to
1260: from gl_period_statuses gl
1261: --, ar_system_parameters ar
1262: where gl.end_date >= P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH
1263: and gl.set_of_books_id = P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID
1264: ---l_set_of_books_id