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.JA_CN_POST_UTILITY_PKG dependencies on GL_BALANCES

Line 163: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;

159: l_ret_project_number ja_cn_account_balances.company_segment%TYPE;
160: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;
161: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
162:
163: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
164: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
165: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;
166: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;
167:

Line 164: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;

160: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;
161: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
162:
163: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
164: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
165: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;
166: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;
167:
168: l_ret_account_type ja_cn_account_balances.account_type%TYPE;

Line 165: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;

161: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
162:
163: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
164: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
165: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;
166: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;
167:
168: l_ret_account_type ja_cn_account_balances.account_type%TYPE;
169:

Line 166: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;

162:
163: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
164: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
165: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;
166: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;
167:
168: l_ret_account_type ja_cn_account_balances.account_type%TYPE;
169:
170: l_cost_center_second_tracking BOOLEAN:=FALSE;

Line 497: , gl_balances gb

493: , l_ret_acct_balance_dr_beq
494: , l_ret_acct_balance_cr_beq
495: , l_ret_currence_code
496: FROM gl_ledgers sob
497: , gl_balances gb
498: WHERE sob.ledger_id = p_ledger_id
499: AND sob.ret_earn_code_combination_id = gb.code_combination_id
500: AND gb.ledger_id = p_ledger_id
501: AND gb.period_name = p_period_name

Line 1268: FROM gl_balances gb

1264: ( SELECT sum(nvl(gb.begin_balance_dr_beq,gb.begin_balance_dr))
1265: , sum(nvl(gb.begin_balance_cr_beq,gb.begin_balance_cr))
1266: , sum(gb.begin_balance_dr)
1267: , sum(gb.begin_balance_cr)
1268: FROM gl_balances gb
1269: , ja_cn_code_combination_v jcc
1270: , ja_cn_code_combination_v jcc1
1271: WHERE gb.ledger_id = p_ledger_id
1272: AND jcc.ledger_id = p_ledger_id

Line 1496: FROM gl_balances gb

1492: , SYSDATE
1493: , fnd_global.USER_ID
1494: , SYSDATE
1495: , fnd_global.LOGIN_ID
1496: FROM gl_balances gb
1497: , ja_cn_code_combination_v jcc
1498: , fnd_flex_values ffv
1499: WHERE gb.ledger_id = p_ledger_id
1500: AND jcc.ledger_id = p_ledger_id