APPS.OKC_XPRT_UTIL_PVT dependencies on FND_FLEX_VALUES_VL

Line 4922: from fnd_flex_values_vl value

4918:
4919: /*CURSOR c2 IS
4920: select value.flex_value
4921: --,value.description
4922: from fnd_flex_values_vl value
4923: where value.FLEX_VALUE_SET_ID = p_object_value_set_id
4924: and enabled_flag='Y'
4925: and trunc(sysdate) between nvl(trunc(start_date_active),trunc(sysdate)) and nvl(trunc(end_date_active),trunc(sysdate))
4926: */

Line 5666: from fnd_flex_values_vl value

5662: RETURN VARCHAR2 IS
5663: CURSOR c1 IS
5664: select value.flex_value
5665: --,value.description
5666: from fnd_flex_values_vl value
5667: where value.FLEX_VALUE_SET_ID = p_object_value_set_id
5668: and enabled_flag='Y'
5669: and trunc(sysdate) between nvl(trunc(start_date_active),trunc(sysdate)) and nvl(trunc(end_date_active),trunc(sysdate))
5670: and value.flex_value_id = to_number(p_object_value_code);

Line 5776: from fnd_flex_values_vl value

5772:
5773: RETURN VARCHAR2 IS
5774: CURSOR c1 IS
5775: select value.description
5776: from fnd_flex_values_vl value
5777: where value.FLEX_VALUE_SET_ID = p_object_value_set_id
5778: and enabled_flag='Y'
5779: and trunc(sysdate) between nvl(trunc(start_date_active),trunc(sysdate)) and nvl(trunc(end_date_active),trunc(sysdate))
5780: and value.flex_value_id = to_number(p_object_value_code);