DBA Data[Home] [Help]

APPS.GMF_GL_GET_BALANCES dependencies on GL_BALANCES

Line 21: SELECT /*+ index(glbal gl_balances_n1 ) */

17: , l_segment_delimiter VARCHAR2
18: , l_currency_code gl_sets_of_books.currency_code%TYPE -- Bug 4066174 Added
19: )
20: IS
21: SELECT /*+ index(glbal gl_balances_n1 ) */
22: in_set_of_books,
23: glcc.chart_of_accounts_id,
24: glbal.period_year,
25: glbal.period_num,

Line 67: gl_balances glbal

63: (period_net_dr - period_net_cr)),
64: l_segment_delimiter
65: FROM
66: gl_code_combinations glcc,
67: gl_balances glbal
68: WHERE
69: glbal.code_combination_id = glcc.code_combination_id
70: AND glbal.period_year = in_period_year
71: AND glbal.period_num = in_period_num