APPS.OKC_XPRT_CUSTOM_PACKAGE dependencies on FND_FLEX_VALUES_VL

Line 320: -- Modified on 03232007 to return Value id instead of Value name from fnd_flex_values_vl

316: -- (select component_id from ASO_SUP_component_tl where component_name = p_comp_name and language = 'US');
317:
318:
319: --cursor to get LOV values
320: -- Modified on 03232007 to return Value id instead of Value name from fnd_flex_values_vl
321:
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

Line 324: FROM fnd_flex_values_vl

320: -- Modified on 03232007 to return Value id instead of Value name from fnd_flex_values_vl
321:
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'

Line 1085: FROM fnd_flex_values_vl ffvv,okc_bus_variables_b obvb

1081: WHERE HEADER_ID = P_DOC_ID;
1082:
1083: Cursor l_flex_value_id_csr(p_flex_value varchar2) is
1084: SELECT flex_value_id
1085: FROM fnd_flex_values_vl ffvv,okc_bus_variables_b obvb
1086: WHERE ffvv.flex_value_set_id = obvb.VALUE_SET_ID and
1087: obvb.VARIABLE_CODE = p_variable_code and
1088: ffvv.FLEX_VALUE = p_flex_value;
1089: