APPS.FV_FACTS_TRANSACTIONS dependencies on GL_CODE_COMBINATIONS

Line 83: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;

79: v_period_num gl_period_statuses.period_num%TYPE ;
80: --v_debug varchar2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
81: v_year_gtn2001 BOOLEAN ;
82: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
83: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;
84: v_acc_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
85: v_bal_seg_name VARCHAR2(20);
86: v_acc_seg_name VARCHAR2(20);
87: v_fyr_segment_name VARCHAR2(20);

Line 1254: GL_CODE_COMBINATIONS GLCC,

1250: ', GLCC.' || v_bal_seg_name ||
1251: ', GLCC.' || v_fyr_segment_name ||
1252: v_cohort_select ||
1253: ' FROM GL_BALANCES GLB,
1254: GL_CODE_COMBINATIONS GLCC,
1255: FV_FUND_PARAMETERS FFP,
1256: FV_TREASURY_SYMBOLS FTS
1257: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1258: AND GLB.code_combination_id = GLCC.code_combination_id

Line 1291: GL_CODE_COMBINATIONS GLCC,

1287: ',SUM(decode(glb.period_name,:b_period_name,glb.begin_balance_dr - glb.begin_balance_cr,0)) beg_amt
1288: ,SUM(decode(glb.period_name,:e_period_name,glb.begin_balance_dr - glb.begin_balance_cr +
1289: glb.period_net_dr - glb.period_net_cr,0)) end_amount
1290: FROM GL_BALANCES GLB,
1291: GL_CODE_COMBINATIONS GLCC,
1292: FV_FUND_PARAMETERS FFP,
1293: FV_TREASURY_SYMBOLS FTS
1294: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1295: AND FTS.SET_OF_BOOKS_ID = :set_of_books_id

Line 1883: gl_code_combinations glcc,

1879: gjl.effective_date , gjl.period_name, gjh.je_source '||
1880: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1881: va_advance_type_col ||
1882: ' FROM gl_je_lines gjl,
1883: gl_code_combinations glcc,
1884: gl_je_headers gjh
1885: WHERE gjl.code_combination_id = glcc.code_combination_id
1886: AND gjl.status = :je_status
1887: AND gjl.ledger_id = :set_of_books_id

Line 1919: gl_code_combinations glcc,

1915: gjl.effective_date , gjl.period_name, gjh.je_source '||
1916: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1917: va_advance_type_col ||
1918: ' FROM gl_je_lines gjl,
1919: gl_code_combinations glcc,
1920: gl_je_headers gjh,
1921: gl_import_references gli,
1922: xla_distribution_links xdl,
1923: xla_ae_lines xl

Line 4243: gl_code_combinations glcc

4239: '''' || 'E' || '''' || ', SUM((glb.begin_balance_dr -
4240: glb.begin_balance_cr) + (glb.period_net_dr - period_net_cr ))),0),
4241: SUM(glb.period_net_dr - glb.period_net_cr)
4242: FROM gl_balances glb,
4243: gl_code_combinations glcc
4244: WHERE glb.code_combination_id = glcc.code_combination_id ';
4245:
4246: vl_bal_select :=
4247: vl_bal_select ||' AND glb.actual_flag = :actual_flag

Line 4446: gl_code_combinations glcc

4442: '''' || 'E' || '''' || ', SUM((glb.begin_balance_dr -
4443: glb.begin_balance_cr) + (glb.period_net_dr - period_net_cr ))),0) '||
4444: v_cohort_select ||
4445: ' FROM gl_balances glb,
4446: gl_code_combinations glcc
4447: WHERE glb.code_combination_id = GLCC.code_combination_id
4448: AND '||'glb.actual_flag = :actual_flag
4449: AND GLCC.'|| v_bal_seg_name ||' = :fund_value
4450: AND GLCC.' || v_acc_seg_name ||' = :acct_number