APPS.GL_RX_TRIAL_BALANCE_PKG dependencies on GL_CODE_COMBINATIONS

Line 41: l_balancing GL_CODE_COMBINATIONS.segment1%type;

37: l_balancing_segment_column FND_ID_FLEX_SEGMENTS.application_column_name%type;
38: l_account_segment_column FND_ID_FLEX_SEGMENTS.application_column_name%type;
39: l_balancing_description FND_FLEX_VALUES_TL.description%type;
40: l_account_description FND_FLEX_VALUES_TL.description%type;
41: l_balancing GL_CODE_COMBINATIONS.segment1%type;
42: l_account GL_CODE_COMBINATIONS.segment1%type;
43: l_rowid rowid;
44: l_dyn_stmt VARCHAR2(4000);
45: l_dyn_cursor number;

Line 42: l_account GL_CODE_COMBINATIONS.segment1%type;

38: l_account_segment_column FND_ID_FLEX_SEGMENTS.application_column_name%type;
39: l_balancing_description FND_FLEX_VALUES_TL.description%type;
40: l_account_description FND_FLEX_VALUES_TL.description%type;
41: l_balancing GL_CODE_COMBINATIONS.segment1%type;
42: l_account GL_CODE_COMBINATIONS.segment1%type;
43: l_rowid rowid;
44: l_dyn_stmt VARCHAR2(4000);
45: l_dyn_cursor number;
46: l_dyn_rows number;

Line 284: gl_code_combinations gcc

280: nvl(period_net_dr,0), 0)),
281: sum(decode(period_name,'||''''||p_period_name||''''||',
282: nvl(period_net_cr,0), 0))
283: FROM gl_balances bal,
284: gl_code_combinations gcc
285: WHERE bal.code_combination_id = gcc.code_combination_id
286: AND bal.ledger_id = '||to_char(l_ledger_id)||'
287: AND bal.currency_code = '||''''||l_currency_code||''''||'
288: AND bal.period_name in ('||''''||p_period_name||''''||','||