APPS.XLA_GL_TRANSFER_PKG dependencies on GL_PERIOD_STATUSES

Line 302: FROM gl_period_statuses gps

298: CURSOR c_getClosedPeriods(c_sob_id NUMBER,
299: c_start_date DATE,
300: c_end_date DATE ) IS
301: SELECT gps.period_name, gps.start_date, gps.end_date, gps.closing_status
302: FROM gl_period_statuses gps
303: WHERE gps.application_id = 101
304: AND gps.set_of_books_id = c_sob_id
305: AND Nvl(gps.adjustment_period_flag,'N') = 'N'
306: AND gps.end_date >= c_start_date

Line 333: FROM gl_period_statuses

329: -- period and end date of the last open period.
330: BEGIN
331: SELECT min(start_date), max(end_date)
332: INTO l_open_start_date, l_open_end_date
333: FROM gl_period_statuses
334: WHERE application_id = 101
335: AND set_of_books_id = p_sob_list(i).sob_id
336: AND Nvl(adjustment_period_flag,'N') = 'N'
337: AND closing_status IN ( 'O','F');

Line 2194: l_next_period gl_period_statuses.period_name%TYPE;

2190: l_open_start_date DATE;
2191: l_open_end_date DATE;
2192: l_min_start_date DATE;
2193: l_max_end_date DATE;
2194: l_next_period gl_period_statuses.period_name%TYPE;
2195: l_reversal_date DATE; -- Bug #974204
2196: l_application_id NUMBER(15);
2197: l_period_status VARCHAR2(1);
2198: l_period_name gl_period_statuses.period_name%TYPE;

Line 2198: l_period_name gl_period_statuses.period_name%TYPE;

2194: l_next_period gl_period_statuses.period_name%TYPE;
2195: l_reversal_date DATE; -- Bug #974204
2196: l_application_id NUMBER(15);
2197: l_period_status VARCHAR2(1);
2198: l_period_name gl_period_statuses.period_name%TYPE;
2199: l_transfer_run_id NUMBER;
2200: l_set_of_books_id NUMBER;
2201: l_batch_run_id NUMBER;
2202: l_gl_installed_flag VARCHAR2(10);

Line 2231: FROM gl_period_statuses gp1,

2227: c_start_date DATE,
2228: c_end_date DATE) IS
2229: SELECT gp1.period_name, gp1.start_date, gp1.end_date,
2230: gp2.period_name, gp2.start_date
2231: FROM gl_period_statuses gp1,
2232: gl_period_statuses gp2
2233: WHERE gp1.application_id = 101
2234: AND gp1.set_of_books_id = c_sob_id
2235: AND gp1.end_date >= Nvl(c_start_date,gp1.end_date-1)

Line 2232: gl_period_statuses gp2

2228: c_end_date DATE) IS
2229: SELECT gp1.period_name, gp1.start_date, gp1.end_date,
2230: gp2.period_name, gp2.start_date
2231: FROM gl_period_statuses gp1,
2232: gl_period_statuses gp2
2233: WHERE gp1.application_id = 101
2234: AND gp1.set_of_books_id = c_sob_id
2235: AND gp1.end_date >= Nvl(c_start_date,gp1.end_date-1)
2236: AND gp1.start_date <= c_end_date