DBA Data[Home] [Help]

APPS.GMF_GL_GET_BALANCES dependencies on GL_CODE_COMBINATIONS

Line 68: gl_code_combinations glcc,

64: (period_net_dr - period_net_cr)),
65: l_segment_delimiter
66: , glcc.code_combination_id ccid /*B12600219 - Fetching ccid of the account
67: FROM
68: gl_code_combinations glcc,
69: gl_balances glbal
70: WHERE
71: glbal.ledger_id = in_set_of_books /* this is used as ledger id INVCONV sschinch*
72: AND glbal.code_combination_id = glcc.code_combination_id

Line 147: FROM gl_code_combinations glcc

143: glcc.segment27||l_segment_delimiter||
144: glcc.segment28||l_segment_delimiter||
145: glcc.segment29||l_segment_delimiter||
146: glcc.segment30 code_combinations
147: FROM gl_code_combinations glcc
148: WHERE glcc.code_combination_id = in_account_ccid ;
149: /*Bug#1260021 (START) - Cursor for building 30-segmented account with sequential segments*/
150:
151: PROCEDURE fetch_segment_values

Line 494: ' gl_code_combinations glcc, '||

490: '(glbal.begin_balance_dr - glbal.begin_balance_cr)+(period_net_dr - period_net_cr) ) amount,'''
491: ||l_segment_delimiter||
492: ''',glcc.code_combination_id ccid'||
493: ' FROM ' ||
494: ' gl_code_combinations glcc, '||
495: ' gl_balances glbal '||
496: ' WHERE '||
497: 'glbal.ledger_id = '|| in_set_of_books||
498: ' AND glbal.code_combination_id = glcc.code_combination_id' ||