APPS.JA_CN_POST_UTILITY_PKG dependencies on GL_BALANCES

Line 200: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;

196: l_ret_project_number ja_cn_account_balances.company_segment%TYPE;
197: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;
198: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
199:
200: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
201: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
202: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;
203: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;
204:

Line 201: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;

197: l_ret_project_id ja_cn_account_balances.cost_center%TYPE;
198: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
199:
200: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
201: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
202: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;
203: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;
204:
205: l_ret_account_type ja_cn_account_balances.account_type%TYPE;

Line 202: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;

198: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
199:
200: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
201: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
202: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;
203: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;
204:
205: l_ret_account_type ja_cn_account_balances.account_type%TYPE;
206:

Line 203: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;

199:
200: l_ret_acct_balance_dr gl_balances.begin_balance_dr%TYPE;
201: l_ret_acct_balance_cr gl_balances.begin_balance_cr%TYPE;
202: l_ret_acct_balance_dr_beq gl_balances.begin_balance_dr_beq%TYPE;
203: l_ret_acct_balance_cr_beq gl_balances.begin_balance_cr_beq%TYPE;
204:
205: l_ret_account_type ja_cn_account_balances.account_type%TYPE;
206:
207: l_cost_center_second_tracking BOOLEAN:=FALSE;

Line 594: , gl_balances gb

590: , l_ret_acct_balance_dr_beq
591: , l_ret_acct_balance_cr_beq
592: , l_ret_currence_code
593: FROM gl_ledgers sob
594: , gl_balances gb
595: WHERE sob.ledger_id = p_ledger_id
596: AND sob.ret_earn_code_combination_id = gb.code_combination_id
597: AND gb.ledger_id = p_ledger_id
598: AND gb.period_name = p_period_name

Line 1536: , gl_balances gb

1532: , jcc.SEGMENT30
1533: FROM ja_cn_code_combination_v jcc
1534: , FND_FLEX_VALUES ffv
1535: , ja_cn_periods jcp
1536: , gl_balances gb
1537: , ja_cn_code_combination_v jcc1
1538: WHERE jcc.ledger_id = p_ledger_id --parameter: p_ledger_id
1539: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1540: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id --variable: l_flex_value_set_id

Line 1993: FROM gl_balances gb

1989: ( SELECT sum(nvl(gb.begin_balance_dr_beq,gb.begin_balance_dr))
1990: , sum(nvl(gb.begin_balance_cr_beq,gb.begin_balance_cr))
1991: , sum(gb.begin_balance_dr)
1992: , sum(gb.begin_balance_cr)
1993: FROM gl_balances gb
1994: , ja_cn_code_combination_v jcc
1995: , ja_cn_code_combination_v jcc1
1996: WHERE gb.ledger_id = p_ledger_id
1997: AND jcc.ledger_id = p_ledger_id

Line 2024: FROM gl_balances gb

2020: ( SELECT sum(nvl(gb.begin_balance_dr_beq,gb.begin_balance_dr))
2021: , sum(nvl(gb.begin_balance_cr_beq,gb.begin_balance_cr))
2022: , sum(gb.begin_balance_dr)
2023: , sum(gb.begin_balance_cr)
2024: FROM gl_balances gb
2025: , ja_cn_code_combination_v jcc
2026: , ja_cn_code_combination_v jcc1
2027: WHERE gb.ledger_id = p_ledger_id
2028: AND jcc.ledger_id = p_ledger_id

Line 2376: FROM gl_balances gb

2372: , SYSDATE
2373: , fnd_global.USER_ID
2374: , SYSDATE
2375: , fnd_global.LOGIN_ID
2376: FROM gl_balances gb
2377: , ja_cn_code_combination_v jcc
2378: , fnd_flex_values ffv
2379: WHERE gb.ledger_id = p_ledger_id
2380: AND jcc.ledger_id = p_ledger_id