APPS.OKC_XPRT_UTIL_PVT dependencies on FND_FLEX_VALUES_VL

Line 5120: from fnd_flex_values_vl value

5116:
5117: /*CURSOR c2 IS
5118: select value.flex_value
5119: --,value.description
5120: from fnd_flex_values_vl value
5121: where value.FLEX_VALUE_SET_ID = p_object_value_set_id
5122: and enabled_flag='Y'
5123: and trunc(sysdate) between nvl(trunc(start_date_active),trunc(sysdate)) and nvl(trunc(end_date_active),trunc(sysdate))
5124: */

Line 5864: from fnd_flex_values_vl value

5860: RETURN VARCHAR2 IS
5861: CURSOR c1 IS
5862: select value.flex_value
5863: --,value.description
5864: from fnd_flex_values_vl value
5865: where value.FLEX_VALUE_SET_ID = p_object_value_set_id
5866: and enabled_flag='Y'
5867: and trunc(sysdate) between nvl(trunc(start_date_active),trunc(sysdate)) and nvl(trunc(end_date_active),trunc(sysdate))
5868: and value.flex_value_id = to_number(p_object_value_code);

Line 5974: from fnd_flex_values_vl value

5970:
5971: RETURN VARCHAR2 IS
5972: CURSOR c1 IS
5973: select value.description
5974: from fnd_flex_values_vl value
5975: where value.FLEX_VALUE_SET_ID = p_object_value_set_id
5976: and enabled_flag='Y'
5977: and trunc(sysdate) between nvl(trunc(start_date_active),trunc(sysdate)) and nvl(trunc(end_date_active),trunc(sysdate))
5978: and value.flex_value_id = to_number(p_object_value_code);