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 2197: l_next_period gl_period_statuses.period_name%TYPE;

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

Line 2201: l_period_name gl_period_statuses.period_name%TYPE;

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

Line 2234: FROM gl_period_statuses gp1,

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

Line 2235: gl_period_statuses gp2

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