APPS.FV_FACTS_TBAL_TRX dependencies on FND_FLEX_VALUES

Line 2944: From fnd_flex_values_tl ffvl,

2940: -- Get the Apportionment Category B Text
2941: Select Decode(ffvl.Description,
2942: NULL, RPAD(' ',25,' '), RPAD(ffvl.Description,25,' '))
2943: Into p_seg_txt
2944: From fnd_flex_values_tl ffvl,
2945: fnd_flex_values ffv
2946: where ffvl.flex_value_id = ffv.flex_value_id
2947: AND ffv.flex_value_set_id = p_prg_val_set_id
2948: AND ffv.flex_value = p_program

Line 2945: fnd_flex_values ffv

2941: Select Decode(ffvl.Description,
2942: NULL, RPAD(' ',25,' '), RPAD(ffvl.Description,25,' '))
2943: Into p_seg_txt
2944: From fnd_flex_values_tl ffvl,
2945: fnd_flex_values ffv
2946: where ffvl.flex_value_id = ffv.flex_value_id
2947: AND ffv.flex_value_set_id = p_prg_val_set_id
2948: AND ffv.flex_value = p_program
2949: AND ffvl.language = userenv('LANG');

Line 2983: From fnd_flex_values

2979:
2980: -- Get the Account Type from fnd Tables
2981: Select substr(compiled_value_attributes, 5, 1)
2982: Into acct_type
2983: From fnd_flex_values
2984: where flex_value_set_id = v_acc_val_set_id
2985: and flex_value = acct_num ;
2986:
2987: If acct_type IS NULL Then

Line 3550: FROM fnd_flex_values_vl

3546: vl_bal_flex_id fnd_id_flex_segments.flex_value_set_id%type;
3547: CURSOR C_Get_Fund_Values
3548: IS
3549: SELECT flex_value
3550: FROM fnd_flex_values_vl
3551: WHERE flex_value_set_id = vl_bal_flex_id
3552: AND flex_value between vp_fund_low and vp_fund_high
3553: AND summary_flag = 'N';
3554:

Line 3558: FROM fnd_flex_values_vl

3554:
3555: CURSOR C_Get_Rec_Count
3556: IS
3557: SELECT count(*) cnt
3558: FROM fnd_flex_values_vl
3559: WHERE flex_value_set_id = vl_bal_flex_id
3560: AND flex_value between vp_fund_low and vp_fund_high
3561: AND summary_flag = 'N';
3562: