APPS.FV_GTAS_INTERFACE dependencies on GL_BALANCES

Line 150: gbl_period_num Gl_Balances.period_num%TYPE;

146: PROCEDURE del_disabled_accts(p_acct_num IN VARCHAR2);
147:
148: gbl_fund_range_low FV_Fund_Parameters.fund_value%TYPE;
149: gbl_fund_range_high FV_Fund_Parameters.fund_value%TYPE;
150: gbl_period_num Gl_Balances.period_num%TYPE;
151: gbl_period_year gl_period_statuses.period_year%TYPE;
152:
153: g_Treasury_Symbol_Low_id number(15);
154: g_Treasury_Symbol_high_id number(15);

Line 2015: ' FROM gl_balances glb,gl_code_combinations GLC

2011: SUM (DECODE (period_num, :gbl_period_num_high,
2012: (NVL(period_net_cr,0)),0)) period_cy_cr_bal,
2013: SUM (DECODE (period_num, :gbl_period_num_high,
2014: (begin_balance_dr - begin_balance_cr),0)) period_begin_bal '||
2015: ' FROM gl_balances glb,gl_code_combinations GLC
2016: WHERE glb.actual_flag = '||''''||'A'||''''||'
2017: AND period_year = :gbl_fiscal_year
2018: AND period_num IN (:gbl_period_num_low, :gbl_period_num_high)
2019: AND glb.ledger_id = :gbl_set_of_books_id