APPS.FV_FACTS_TBAL_TRX dependencies on FND_FLEX_VALUES

Line 2733: From fnd_flex_values_tl ffvl,

2729: -- Get the Apportionment Category B Text
2730: Select Decode(ffvl.Description,
2731: NULL, RPAD(' ',25,' '), RPAD(ffvl.Description,25,' '))
2732: Into p_seg_txt
2733: From fnd_flex_values_tl ffvl,
2734: fnd_flex_values ffv
2735: where ffvl.flex_value_id = ffv.flex_value_id
2736: AND ffv.flex_value_set_id = p_prg_val_set_id
2737: AND ffv.flex_value = p_program

Line 2734: fnd_flex_values ffv

2730: Select Decode(ffvl.Description,
2731: NULL, RPAD(' ',25,' '), RPAD(ffvl.Description,25,' '))
2732: Into p_seg_txt
2733: From fnd_flex_values_tl ffvl,
2734: fnd_flex_values ffv
2735: where ffvl.flex_value_id = ffv.flex_value_id
2736: AND ffv.flex_value_set_id = p_prg_val_set_id
2737: AND ffv.flex_value = p_program
2738: AND ffvl.language = userenv('LANG');

Line 2772: From fnd_flex_values

2768:
2769: -- Get the Account Type from fnd Tables
2770: Select substr(compiled_value_attributes, 5, 1)
2771: Into acct_type
2772: From fnd_flex_values
2773: where flex_value_set_id = v_acc_val_set_id
2774: and flex_value = acct_num ;
2775:
2776: If acct_type IS NULL Then

Line 3250: FROM fnd_flex_values_vl

3246: vl_bal_flex_id fnd_id_flex_segments.flex_value_set_id%type;
3247: CURSOR C_Get_Fund_Values
3248: IS
3249: SELECT flex_value
3250: FROM fnd_flex_values_vl
3251: WHERE flex_value_set_id = vl_bal_flex_id
3252: AND flex_value between vp_fund_low and vp_fund_high
3253: AND summary_flag = 'N';
3254:

Line 3258: FROM fnd_flex_values_vl

3254:
3255: CURSOR C_Get_Rec_Count
3256: IS
3257: SELECT count(*) cnt
3258: FROM fnd_flex_values_vl
3259: WHERE flex_value_set_id = vl_bal_flex_id
3260: AND flex_value between vp_fund_low and vp_fund_high
3261: AND summary_flag = 'N';
3262: