APPS.FV_FACTS1_PKG dependencies on GL_CODE_COMBINATIONS

Line 1801: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,

1797: --------------------------------------------------------------------------------------------------------
1798: PROCEDURE TRIAL_BALANCE_MAIN (p_errbuf OUT NOCOPY Varchar2,
1799: p_retcode OUT NOCOPY Number,
1800: p_sob Gl_ledgers_public_v.ledger_id%TYPE,
1801: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,
1802: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,
1803: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,
1804: p_currency_code Varchar2,
1805: p_period_name Varchar2,

Line 2057: FROM fv_facts_period_balances_tb_v t2, gl_code_combinations gcc

2053: --SUM(beginning_balance),
2054: SUM(period_begin_bal),
2055: SUM(nvl(period_dr,0)),
2056: SUM(nvl(period_cr,0)) '|| l_group_by ||'
2057: FROM fv_facts_period_balances_tb_v t2, gl_code_combinations gcc
2058: WHERE t2.set_of_books_id = :gbl_set_of_books_id
2059: AND t2.ccid = gcc.code_combination_id
2060: AND t2.period_num <= :gbl_period_num_high
2061: AND t2.period_year = :gbl_fiscal_year

Line 2340: ' FROM gl_balances glb,gl_code_combinations GLC

2336: SUM (DECODE (period_num, :gbl_period_num_high,
2337: (NVL(period_net_cr,0)),0)) period_cy_cr_bal,
2338: SUM (DECODE (period_num, :gbl_period_num_high,
2339: (begin_balance_dr - begin_balance_cr),0)) period_begin_bal '||
2340: ' FROM gl_balances glb,gl_code_combinations GLC
2341: WHERE glb.actual_flag = '||''''||'A'||''''||'
2342: AND period_year = :gbl_fiscal_year
2343: AND period_num IN (:gbl_period_num_low, :gbl_period_num_high)
2344: AND glb.ledger_id = :gbl_set_of_books_id