DBA Data[Home] [Help]

APPS.OKC_XPRT_OM_INT_PVT dependencies on FND_FLEX_VALUE_SETS

Line 160: from fnd_flex_values a, fnd_flex_value_sets b

156: -- Cursor to fetch the flex value id for Yes and No from the OKC_XPRT_YES_NO value set
157: --
158: CURSOR c_get_expert_yes_no(p_yes_no VARCHAR2) IS
159: select a.FLEX_VALUE_ID
160: from fnd_flex_values a, fnd_flex_value_sets b
161: where b.flex_value_set_name = 'OKC_XPRT_YES_NO'
162: and a.FLEX_VALUE_SET_ID = b.FLEX_VALUE_SET_ID
163: and a.FLEX_VALUE = p_yes_no;
164: