DBA Data[Home] [Help]

APPS.OKC_XPRT_OM_INT_PVT dependencies on FND_FLEX_VALUE_SETS

Line 121: from fnd_flex_values a, fnd_flex_value_sets b

117: -- Cursor to fetch the flex value id for Yes and No from the OKC_XPRT_YES_NO value set
118: --
119: CURSOR c_get_expert_yes_no(p_yes_no VARCHAR2) IS
120: select a.FLEX_VALUE_ID
121: from fnd_flex_values a, fnd_flex_value_sets b
122: where b.flex_value_set_name = 'OKC_XPRT_YES_NO'
123: and a.FLEX_VALUE_SET_ID = b.FLEX_VALUE_SET_ID
124: and a.FLEX_VALUE = p_yes_no;
125: