APPS.FV_FUNDS_AVAILABLE_PKG dependencies on GL_BALANCES

Line 74: --sob_id gl_balances.set_of_books_id%TYPE;

70: segment_5 varchar2(25);
71: segment_6 varchar2(25);
72: segment_7 varchar2(25);
73: acct_seg_name_num number(2);
74: --sob_id gl_balances.set_of_books_id%TYPE;
75: sob_id gl_balances.ledger_id%TYPE;
76: curr_code gl_balances.currency_code%TYPE;
77: pd_name gl_balances.period_name%TYPE;
78: v_period_year gl_period_statuses.period_year%TYPE;

Line 75: sob_id gl_balances.ledger_id%TYPE;

71: segment_6 varchar2(25);
72: segment_7 varchar2(25);
73: acct_seg_name_num number(2);
74: --sob_id gl_balances.set_of_books_id%TYPE;
75: sob_id gl_balances.ledger_id%TYPE;
76: curr_code gl_balances.currency_code%TYPE;
77: pd_name gl_balances.period_name%TYPE;
78: v_period_year gl_period_statuses.period_year%TYPE;
79: v_period_status gl_period_statuses.closing_status%TYPE;

Line 76: curr_code gl_balances.currency_code%TYPE;

72: segment_7 varchar2(25);
73: acct_seg_name_num number(2);
74: --sob_id gl_balances.set_of_books_id%TYPE;
75: sob_id gl_balances.ledger_id%TYPE;
76: curr_code gl_balances.currency_code%TYPE;
77: pd_name gl_balances.period_name%TYPE;
78: v_period_year gl_period_statuses.period_year%TYPE;
79: v_period_status gl_period_statuses.closing_status%TYPE;
80: v_effective_period_num gl_period_statuses.effective_period_num%TYPE;

Line 77: pd_name gl_balances.period_name%TYPE;

73: acct_seg_name_num number(2);
74: --sob_id gl_balances.set_of_books_id%TYPE;
75: sob_id gl_balances.ledger_id%TYPE;
76: curr_code gl_balances.currency_code%TYPE;
77: pd_name gl_balances.period_name%TYPE;
78: v_period_year gl_period_statuses.period_year%TYPE;
79: v_period_status gl_period_statuses.closing_status%TYPE;
80: v_effective_period_num gl_period_statuses.effective_period_num%TYPE;
81:

Line 83: g_curr_code gl_balances.currency_code%TYPE;

79: v_period_status gl_period_statuses.closing_status%TYPE;
80: v_effective_period_num gl_period_statuses.effective_period_num%TYPE;
81:
82:
83: g_curr_code gl_balances.currency_code%TYPE;
84:
85: TYPE t_segment_name_table IS TABLE OF varchar2(25)
86: INDEX BY BINARY_INTEGER;
87: v_segment_name t_segment_name_table;

Line 180: FROM gl_balances glb,

176:
177: v_bal_stmt :=
178: ' SELECT sum((nvl(glb.begin_balance_dr,0) - nvl(glb.begin_balance_cr,0)) +
179: (nvl(glb.period_net_dr,0) - nvl(glb.period_net_cr,0)))
180: FROM gl_balances glb,
181: gl_code_combinations glc
182: WHERE glb.code_combination_id = glc.code_combination_id
183: AND glc.chart_of_accounts_id = ' ||v_ca_id ||
184: ' AND glb.ledger_id = '|| sob_id ||