APPS.FV_FACTS_TRANSACTIONS dependencies on FND_FLEX_VALUES

Line 4118: FROM fnd_flex_values

4114: l_module_name := g_module_name || 'get_account_type';
4115: -- Get the Account Type from fnd Tables
4116: SELECT substr(compiled_value_attributes, 5, 1)
4117: INTO acct_type
4118: FROM fnd_flex_values
4119: WHERE flex_value_set_id = v_acc_val_set_id
4120: AND flex_value = acct_num ;
4121: IF acct_type IS NULL THEN
4122: -- Process Null Account Types

Line 4496: FROM fnd_flex_values_tl ffvl,

4492: -- RPAD(ffvl.description,25,' '))
4493: SELECT DECODE(ffvl.description,NULL,RPAD(' ',25,' '),
4494: RPAD(SUBSTR(ffvl.description,1,25),25,' '))
4495: INTO p_seg_txt
4496: FROM fnd_flex_values_tl ffvl,
4497: fnd_flex_values ffv
4498: WHERE ffvl.flex_value_id = ffv.flex_value_id
4499: AND ffv.flex_value_set_id = p_prg_val_set_id
4500: AND ffv.flex_value = p_program

Line 4497: fnd_flex_values ffv

4493: SELECT DECODE(ffvl.description,NULL,RPAD(' ',25,' '),
4494: RPAD(SUBSTR(ffvl.description,1,25),25,' '))
4495: INTO p_seg_txt
4496: FROM fnd_flex_values_tl ffvl,
4497: fnd_flex_values ffv
4498: WHERE ffvl.flex_value_id = ffv.flex_value_id
4499: AND ffv.flex_value_set_id = p_prg_val_set_id
4500: AND ffv.flex_value = p_program
4501: AND ffvl.language = userenv('LANG');