APPS.FV_FACTS_TRANSACTIONS dependencies on FND_FLEX_VALUES

Line 4190: FROM fnd_flex_values

4186: l_module_name := g_module_name || 'get_account_type';
4187: -- Get the Account Type from fnd Tables
4188: SELECT substr(compiled_value_attributes, 5, 1)
4189: INTO acct_type
4190: FROM fnd_flex_values
4191: WHERE flex_value_set_id = v_acc_val_set_id
4192: AND flex_value = acct_num ;
4193: IF acct_type IS NULL THEN
4194: -- Process Null Account Types

Line 4568: FROM fnd_flex_values_tl ffvl,

4564: -- RPAD(ffvl.description,25,' '))
4565: SELECT DECODE(ffvl.description,NULL,RPAD(' ',25,' '),
4566: RPAD(SUBSTR(ffvl.description,1,25),25,' '))
4567: INTO p_seg_txt
4568: FROM fnd_flex_values_tl ffvl,
4569: fnd_flex_values ffv
4570: WHERE ffvl.flex_value_id = ffv.flex_value_id
4571: AND ffv.flex_value_set_id = p_prg_val_set_id
4572: AND ffv.flex_value = p_program

Line 4569: fnd_flex_values ffv

4565: SELECT DECODE(ffvl.description,NULL,RPAD(' ',25,' '),
4566: RPAD(SUBSTR(ffvl.description,1,25),25,' '))
4567: INTO p_seg_txt
4568: FROM fnd_flex_values_tl ffvl,
4569: fnd_flex_values ffv
4570: WHERE ffvl.flex_value_id = ffv.flex_value_id
4571: AND ffv.flex_value_set_id = p_prg_val_set_id
4572: AND ffv.flex_value = p_program
4573: AND ffvl.language = userenv('LANG');