DBA Data[Home] [Help]

APPS.FV_GTAS_TBAL_TRX_PKG dependencies on GL_CODE_COMBINATIONS

Line 169: P_CHART_OF_ACCOUNTS_ID Gl_Code_Combinations.chart_of_accounts_id%TYPE,

165: PROCEDURE TRIAL_BALANCE_MAIN (
166: --p_errbuf OUT NOCOPY Varchar2,
167: --p_retcode OUT NOCOPY Number,
168: P_LEDGER_ID Gl_ledgers_public_v.ledger_id%TYPE,
169: P_CHART_OF_ACCOUNTS_ID Gl_Code_Combinations.chart_of_accounts_id%TYPE,
170: P_FLEX_LOW IN VARCHAR2,
171: P_FLEX_HIGH IN VARCHAR2,
172: P_PERIOD Varchar2,
173: P_AID_LOW IN VARCHAR2,

Line 370: --FROM fv_gtas1_period_balances_v t2, gl_code_combinations gcc

366: t2.fund_value,
367: t2.period_begin_bal,
368: nvl(t2.period_dr,0),
369: nvl(t2.period_cr,0)
370: --FROM fv_gtas1_period_balances_v t2, gl_code_combinations gcc
371: FROM FV_GTAS_PERIOD_BALANCES_TB_V t2, gl_code_combinations gcc,
372: fv_treasury_symbols fts
373: WHERE t2.set_of_books_id = :gbl_set_of_books_id
374: AND t2.ccid = gcc.code_combination_id

Line 371: FROM FV_GTAS_PERIOD_BALANCES_TB_V t2, gl_code_combinations gcc,

367: t2.period_begin_bal,
368: nvl(t2.period_dr,0),
369: nvl(t2.period_cr,0)
370: --FROM fv_gtas1_period_balances_v t2, gl_code_combinations gcc
371: FROM FV_GTAS_PERIOD_BALANCES_TB_V t2, gl_code_combinations gcc,
372: fv_treasury_symbols fts
373: WHERE t2.set_of_books_id = :gbl_set_of_books_id
374: AND t2.ccid = gcc.code_combination_id
375: AND t2.period_num <= :gbl_period_num_high