APPS.OKC_XPRT_OM_INT_PVT dependencies on FND_FLEX_VALUES

Line 151: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;

147: l_sold_to_org_id NUMBER := NULL;
148: l_invoice_to_site_use_id NUMBER := NULL;
149: l_ship_to_site_use_id NUMBER := NULL;
150: l_deliver_to_site_use_id NUMBER := NULL; --- bug 6899074
151: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;
152: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;
153:
154:
155: --

Line 152: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;

148: l_invoice_to_site_use_id NUMBER := NULL;
149: l_ship_to_site_use_id NUMBER := NULL;
150: l_deliver_to_site_use_id NUMBER := NULL; --- bug 6899074
151: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;
152: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;
153:
154:
155: --
156: -- Cursor to fetch the flex value id for Yes and No from the OKC_XPRT_YES_NO value set

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: