APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on FND_FLEX_VALUE_SETS

Line 326: FROM fnd_flex_value_sets

322: Cursor l_sup_lov_value_csr(p_tmp_instace_id number,p_comp_name varchar2) is
323: SELECT flex_value_id
324: FROM fnd_flex_values_vl
325: WHERE flex_value_set_id = (SELECT flex_value_set_id
326: FROM fnd_flex_value_sets
327: -- Added the Flex vbalue set where condition again on 04162007
328: WHERE flex_value_set_name = 'Industry Type') --1022577 -- Need to be known from setup for 'Industry Type'
329: AND flex_value = (SELECT response_name
330: FROM ASO_SUP_response_tl