APPS.OKC_XPRT_OM_INT_PVT dependencies on FND_FLEX_VALUES

Line 112: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;

108: l_sold_to_site_use_id NUMBER := NULL;
109: l_sold_to_org_id NUMBER := NULL;
110: l_invoice_to_site_use_id NUMBER := NULL;
111: l_ship_to_site_use_id NUMBER := NULL;
112: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;
113: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;
114:
115:
116: --

Line 113: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;

109: l_sold_to_org_id NUMBER := NULL;
110: l_invoice_to_site_use_id NUMBER := NULL;
111: l_ship_to_site_use_id NUMBER := NULL;
112: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;
113: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;
114:
115:
116: --
117: -- Cursor to fetch the flex value id for Yes and No from the OKC_XPRT_YES_NO value set

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: