eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_ZZ_GL_INFL_ADJ_PKG dependencies on GL_BALANCES

Line 124: FROM gl_balances gb

120:
121: SELECT nvl(sum(nvl(gb.begin_balance_dr_beq, 0) - nvl (gb.begin_balance_cr_beq, 0)),0) YTD_AMOUNT,
122: nvl(sum(nvl (gb.period_net_dr_beq, 0) - nvl (gb.period_net_cr_beq, 0)),0) PTD_AMOUNT
123: into p_ytd,p_ptd
124: FROM gl_balances gb
125: WHERE gb.ledger_id = p_set_of_books_id
126: AND gb.code_combination_id = p_code_combination_id
127: AND gb.currency_code <> set_of_books_currency_code
128: AND gb.Period_name = p_period_name

Line 734: || ' , gl_balances gb'

730: || ', gb.period_name'
731: || ', gb.period_year'
732: || ', gb.period_num'
733: || ' FROM gl_code_combinations gcc'
734: || ' , gl_balances gb'
735: || ' , jl_zz_gl_axi_accounts jagaa'
736: || ' WHERE gcc.code_combination_id = gb.code_combination_id'
737: || ' AND gb.ledger_id = ' || p_set_of_books_id
738: || ' AND gb.currency_code = ''' || set_of_books_currency_code||''''

Line 759: || ' , gl_balances gb'

755: || ', gb.period_name'
756: || ', gb.period_year'
757: || ', gb.period_num'
758: || ' FROM gl_code_combinations gcc'
759: || ' , gl_balances gb'
760: || ' , jl_zz_gl_axi_accounts jagaa'
761: || ' WHERE gcc.code_combination_id = gb.code_combination_id'
762: || ' AND gb.ledger_id = :1'
763: --|| ' AND gb.currency_code = ''' || ':2' ||'''' --Bug 3183432