APPS.FV_FACTS_TRANSACTIONS dependencies on GL_CODE_COMBINATIONS

Line 87: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;

83: v_period_num gl_period_statuses.period_num%TYPE ;
84: --v_debug varchar2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
85: v_year_gtn2001 BOOLEAN ;
86: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE ;
87: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;
88: v_acc_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
89: v_bal_seg_name VARCHAR2(20);
90: v_acc_seg_name VARCHAR2(20);
91: v_fyr_segment_name VARCHAR2(20);

Line 1286: GL_CODE_COMBINATIONS GLCC,

1282: ', GLCC.' || v_bal_seg_name ||
1283: ', GLCC.' || v_fyr_segment_name ||
1284: v_cohort_select ||
1285: ' FROM GL_BALANCES GLB,
1286: GL_CODE_COMBINATIONS GLCC,
1287: FV_FUND_PARAMETERS FFP,
1288: FV_TREASURY_SYMBOLS FTS
1289: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1290: AND GLB.code_combination_id = GLCC.code_combination_id

Line 1323: GL_CODE_COMBINATIONS GLCC,

1319: ',SUM(decode(glb.period_name,:b_period_name,glb.begin_balance_dr - glb.begin_balance_cr,0)) beg_amt
1320: ,SUM(decode(glb.period_name,:e_period_name,glb.begin_balance_dr - glb.begin_balance_cr +
1321: glb.period_net_dr - glb.period_net_cr,0)) end_amount
1322: FROM GL_BALANCES GLB,
1323: GL_CODE_COMBINATIONS GLCC,
1324: FV_FUND_PARAMETERS FFP,
1325: FV_TREASURY_SYMBOLS FTS
1326: WHERE FTS.TREASURY_SYMBOL = :treasury_symbol
1327: AND FTS.SET_OF_BOOKS_ID = :set_of_books_id

Line 1919: gl_code_combinations glcc,

1915: gjl.effective_date , gjl.period_name, gjh.je_source '||
1916: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1917: va_advance_type_col ||
1918: ' FROM gl_je_lines gjl,
1919: gl_code_combinations glcc,
1920: gl_je_headers gjh
1921: WHERE gjl.code_combination_id = glcc.code_combination_id
1922: AND gjl.status = :je_status
1923: AND gjl.ledger_id = :set_of_books_id

Line 1955: gl_code_combinations glcc,

1951: gjl.effective_date , gjl.period_name, gjh.je_source '||
1952: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1953: va_advance_type_col ||
1954: ' FROM gl_je_lines gjl,
1955: gl_code_combinations glcc,
1956: gl_je_headers gjh,
1957: gl_import_references gli,
1958: xla_distribution_links xdl,
1959: xla_ae_lines xl

Line 4315: gl_code_combinations glcc

4311: '''' || 'E' || '''' || ', SUM((glb.begin_balance_dr -
4312: glb.begin_balance_cr) + (glb.period_net_dr - period_net_cr ))),0),
4313: SUM(glb.period_net_dr - glb.period_net_cr)
4314: FROM gl_balances glb,
4315: gl_code_combinations glcc
4316: WHERE glb.code_combination_id = glcc.code_combination_id ';
4317:
4318: vl_bal_select :=
4319: vl_bal_select ||' AND glb.actual_flag = :actual_flag

Line 4518: gl_code_combinations glcc

4514: '''' || 'E' || '''' || ', SUM((glb.begin_balance_dr -
4515: glb.begin_balance_cr) + (glb.period_net_dr - period_net_cr ))),0) '||
4516: v_cohort_select ||
4517: ' FROM gl_balances glb,
4518: gl_code_combinations glcc
4519: WHERE glb.code_combination_id = GLCC.code_combination_id
4520: AND '||'glb.actual_flag = :actual_flag
4521: AND GLCC.'|| v_bal_seg_name ||' = :fund_value
4522: AND GLCC.' || v_acc_seg_name ||' = :acct_number