APPS.OKC_XPRT_QUOTE_INT_PVT dependencies on FND_FLEX_VALUES

Line 91: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;

87: l_api_version CONSTANT NUMBER := 1;
88: l_debug Boolean;
89: l_party_id HZ_PARTIES.party_id%type;
90: l_module VARCHAR2(250) := G_MODULE_NAME||l_api_name;
91: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;
92: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;
93:
94: --
95: -- Cursor to fetch the flex value id for Yes and No from the OKC_XPRT_YES_NO value set

Line 92: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;

88: l_debug Boolean;
89: l_party_id HZ_PARTIES.party_id%type;
90: l_module VARCHAR2(250) := G_MODULE_NAME||l_api_name;
91: l_expert_yes FND_FLEX_VALUES.FLEX_VALUE_ID%type;
92: l_expert_no FND_FLEX_VALUES.FLEX_VALUE_ID%type;
93:
94: --
95: -- Cursor to fetch the flex value id for Yes and No from the OKC_XPRT_YES_NO value set
96: --

Line 99: from fnd_flex_values a, fnd_flex_value_sets b

95: -- Cursor to fetch the flex value id for Yes and No from the OKC_XPRT_YES_NO value set
96: --
97: CURSOR c_get_expert_yes_no(p_yes_no VARCHAR2) IS
98: select a.FLEX_VALUE_ID
99: from fnd_flex_values a, fnd_flex_value_sets b
100: where b.flex_value_set_name = 'OKC_XPRT_YES_NO'
101: and a.FLEX_VALUE_SET_ID = b.FLEX_VALUE_SET_ID
102: and a.FLEX_VALUE = p_yes_no;
103: