DBA Data[Home] [Help]

APPS.FV_FACTS1_PKG dependencies on GL_BALANCES

Line 113: gbl_period_num Gl_Balances.period_num%TYPE;

109: gbl_trial_balance_type Varchar2(1) := NULL;
110: gbl_treasury_symbol_id FV_Treasury_Symbols.treasury_symbol_id%TYPE;
111: gbl_fund_range_low FV_Fund_Parameters.fund_value%TYPE;
112: gbl_fund_range_high FV_Fund_Parameters.fund_value%TYPE;
113: gbl_period_num Gl_Balances.period_num%TYPE;
114: gbl_period_year gl_period_statuses.period_year%TYPE;
115:
116: -- Global Variable for RXi
117: gbl_report_id FA_RX_Reports_V.report_id%TYPE;

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