APPS.FV_FACTS1_PKG dependencies on GL_CODE_COMBINATIONS

Line 1842: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,

1838: --------------------------------------------------------------------------------------------------------
1839: PROCEDURE TRIAL_BALANCE_MAIN (p_errbuf OUT NOCOPY Varchar2,
1840: p_retcode OUT NOCOPY Number,
1841: p_sob Gl_ledgers_public_v.ledger_id%TYPE,
1842: p_coa Gl_Code_Combinations.chart_of_accounts_id%TYPE,
1843: p_fund_range_low Fv_Fund_Parameters.fund_value%TYPE,
1844: p_fund_range_high Fv_Fund_Parameters.fund_value%TYPE,
1845: p_currency_code Varchar2,
1846: p_period_name Varchar2,

Line 2110: FROM fv_facts_period_balances_tb_v t2, gl_code_combinations gcc

2106: --SUM(beginning_balance),
2107: SUM(period_begin_bal),
2108: SUM(nvl(period_dr,0)),
2109: SUM(nvl(period_cr,0)) '|| l_group_by ||'
2110: FROM fv_facts_period_balances_tb_v t2, gl_code_combinations gcc
2111: WHERE t2.set_of_books_id = :gbl_set_of_books_id
2112: AND t2.ccid = gcc.code_combination_id
2113: AND t2.period_num <= :gbl_period_num_high
2114: AND t2.period_year = :gbl_fiscal_year

Line 2396: ' FROM gl_balances glb,gl_code_combinations GLC

2392: SUM (DECODE (period_num, :gbl_period_num_high,
2393: (NVL(period_net_cr,0)),0)) period_cy_cr_bal,
2394: SUM (DECODE (period_num, :gbl_period_num_high,
2395: (begin_balance_dr - begin_balance_cr),0)) period_begin_bal '||
2396: ' FROM gl_balances glb,gl_code_combinations GLC
2397: WHERE glb.actual_flag = '||''''||'A'||''''||'
2398: AND period_year = :gbl_fiscal_year
2399: AND period_num IN (:gbl_period_num_low, :gbl_period_num_high)
2400: AND glb.ledger_id = :gbl_set_of_books_id