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 ;
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 ;