1776: g_cache_value.varchar2_1,
1777: g_cache_value.varchar2_2,
1778: g_cache_value.varchar2_3,
1779: g_cache_value.varchar2_4
1780: FROM fnd_descr_flex_contexts_vl
1781: WHERE application_id = appl_id
1782: AND descriptive_flexfield_name = dflex_name
1783: AND ((p_id_or_value = 'I' AND
1784: descriptive_flex_context_code = seg_in) OR
1849: SELECT
1850: descriptive_flex_context_code
1851: INTO
1852: g_cache_value.varchar2_1
1853: FROM fnd_descr_flex_contexts
1854: WHERE application_id = appl_id
1855: AND descriptive_flexfield_name = dflex_name
1856: AND enabled_flag = 'Y'
1857: AND global_flag = 'Y';