APPS.GMF_GL_GET_BALANCES dependencies on GL_PERIODS

Line 233: l_period_name gl_periods.period_name%TYPE;

229: x_start_segments_new varchar2(2000);
230: x_to_segments_new varchar2(2000);
231: /*Bug#12600219 - END *
232:
233: l_period_name gl_periods.period_name%TYPE;
234:
235: BEGIN
236:
237: /***** Bug 4066174 - Added the new queries below *****

Line 297: FROM gl_periods gp, gl_ledgers gl

293:
294: /***** Bug 4066174 - Performance Improvement - Modified the below cursor and its arguments. *****/
295: /* bug 13803220 fetching period_name and passing to the get balances cursor to improve the performance *
296: SELECT gp.period_name INTO l_period_name
297: FROM gl_periods gp, gl_ledgers gl
298: WHERE gp.period_year = in_period_year
299: AND gp.period_num = in_period_num
300: and gp.PERIOD_SET_NAME= gl.PERIOD_SET_NAME
301: and gl.ledger_id = in_set_of_books ;

Line 359: l_period_name gl_periods.period_name%TYPE;

355: x_start_segments_new varchar2(2000);
356: x_to_segments_new varchar2(2000);
357: /*Bug#12600219 - END */
358:
359: l_period_name gl_periods.period_name%TYPE;
360: l_no_of_segments NUMBER :=0;
361: l_sql_stmt VARCHAR2(4000);
362:
363: BEGIN /* Beginning of procedure proc_gl_get_balances*/

Line 441: FROM gl_periods gp, gl_ledgers gl

437:
438: /***** Bug 4066174 - Performance Improvement - Modified the below cursor and its arguments. *****/
439: /* bug 13803220 fetching period_name and passing to the get balances cursor to improve the performance */
440: SELECT gp.period_name INTO l_period_name
441: FROM gl_periods gp, gl_ledgers gl
442: WHERE gp.period_year = in_period_year
443: AND gp.period_num = in_period_num
444: AND gp.PERIOD_SET_NAME= gl.PERIOD_SET_NAME
445: AND gl.ledger_id = in_set_of_books ;