APPS.FV_FUNDS_AVAILABLE_PKG dependencies on GL_BALANCES

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

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

Line 78: sob_id gl_balances.ledger_id%TYPE;

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

Line 79: curr_code gl_balances.currency_code%TYPE;

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

Line 80: pd_name gl_balances.period_name%TYPE;

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

Line 86: g_curr_code gl_balances.currency_code%TYPE;

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

Line 183: FROM gl_balances glb,

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