DBA Data[Home] [Help]

APPS.GMF_GL_GET_BALANCES dependencies on GL_LEDGERS

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