APPS.FV_FACTS_TBAL_TRX dependencies on GL_CODE_COMBINATIONS

Line 140: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;

136: v_catb_prg_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
137: v_prn_prg_val_set_id fnd_flex_value_sets.flex_value_set_id%TYPE ;
138: v_cohort_select Varchar2(20) ;
139: v_cohort_where Varchar2(120) ;
140: v_chart_of_accounts_id gl_code_combinations.chart_of_accounts_id%TYPE ;
141: /*
142: Commented by 7324248
143: v_acct_num fv_Facts_attributes.facts_acct_number%TYPE ;
144: v_g_edit_check_code number(15);

Line 172: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;

168: v_tbal_indicator FV_FACTS_TEMP.TBAL_INDICATOR%TYPE ;
169: v_edit_check_code Number ;
170: v_debug varchar2(1) := NVL(FND_PROFILE.VALUE('FV_DEBUG_FLAG'),'N');
171: v_vl_main_cursor_found varchar2(1) := 'N' ;
172: v_code_combination_id gl_code_combinations.code_combination_id%TYPE;
173: */
174:
175: v_tbal_fund_value FV_FUND_PARAMETERS.FUND_VALUE%TYPE ;
176: v_tbal_acct_num varchar2(25);

Line 851: GL_CODE_COMBINATIONS GLCC

847: v_segment ||
848: v_cohort_select ||
849: v_reimb_agree_select ||
850: ' From GL_BALANCES GLB,
851: GL_CODE_COMBINATIONS GLCC
852: WHERE GLB.code_combination_id = GLCC.code_combination_id ';
853:
854: fv_utility.log_mesg('v_reimb_agree_select ::'||v_reimb_agree_select);
855:

Line 1345: gl_code_combinations glcc,

1341: gjh.je_source ,gjh.je_header_id , gjl.je_line_num , gjh.je_batch_id,je_from_sla_flag '||
1342: va_pl_code_col || va_tr_main_acct_col || va_tr_dept_id_col ||
1343: va_advance_type_col ||
1344: ' From gl_je_lines gjl,
1345: gl_code_combinations glcc,
1346: gl_je_headers gjh
1347: Where gjl.code_combination_id = glcc.code_combination_id
1348: AND glcc.code_combination_id = :ccid ';
1349:

Line 2390: GL_CODE_COMBINATIONS GLCC

2386: GLB.BEGIN_BALANCE_CR) + (GLB.PERIOD_NET_DR - PERIOD_NET_CR ))),0),
2387: SUM(glb.period_net_dr - glb.period_net_cr) ,
2388: SUM(glb.period_net_dr) , sum(glb.period_net_cr)
2389: From GL_BALANCES GLB,
2390: GL_CODE_COMBINATIONS GLCC
2391: WHERE GLB.code_combination_id = GLCC.code_combination_id ';
2392:
2393: -- Data Access Security
2394: das_id := fnd_profile.value('GL_ACCESS_SET_ID');

Line 2582: ' FROM gl_code_combinations glcc

2578:
2579: --get the reimb agree seg value from the ccid
2580: vl_reimb_agree_sel :=
2581: ' SELECT glcc.'||g_reimb_agree_seg_name||
2582: ' FROM gl_code_combinations glcc
2583: WHERE glcc.code_combination_id = :ccid
2584: AND chart_of_accounts_id = '||vp_coa_id;
2585:
2586: EXECUTE IMMEDIATE vl_reimb_agree_sel INTO

Line 3113: GL_CODE_COMBINATIONS GLCC

3109: ' SUM(GLB.PERIOD_NET_DR - PERIOD_NET_CR ), '||
3110: ' SUM(GLB.PERIOD_NET_DR) period_dr , sum( PERIOD_NET_CR ) period_cr '||
3111: v_cohort_select ||
3112: ' From GL_BALANCES GLB,
3113: GL_CODE_COMBINATIONS GLCC
3114: WHERE GLB.code_combination_id = GLCC.code_combination_id
3115: AND glcc.code_combination_id = :ccid
3116: AND glb.actual_flag = :actual_flag
3117: AND GLCC.'|| v_bal_seg_name ||' = :Fund_Value

Line 3301: ' From FV_FACTS_TEMP fvt, gl_code_combinations glcc

3297: SUM(AMOUNT1),
3298: SUM(AMOUNT2),
3299: SUM(decode(begin_end , ''P'' , 0 , period_activity )) '
3300: || vl_group_by ||
3301: ' From FV_FACTS_TEMP fvt, gl_code_combinations glcc
3302: WHERE fct_int_record_category = ''REPORTED''
3303: AND fct_int_record_type = ''TB''
3304: AND tbal_fund_value = ' || '''' || v_fund_value || ''''
3305: || ' and glcc.code_combination_id = fvt.code_combination_id