DBA Data[Home] [Help]

APPS.OKC_XPRT_QA_PVT dependencies on FND_FLEX_VALUES_VL

Line 1143: FROM fnd_flex_values_vl

1139:
1140: -- SQL for Valueset type Independent
1141: CURSOR csr_value_set_ind(p_flex_value_id IN NUMBER) IS
1142: SELECT 'x'
1143: FROM fnd_flex_values_vl
1144: WHERE flex_value_id = p_flex_value_id
1145: AND enabled_flag = 'Y'
1146: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1);
1147:

Line 1546: FROM fnd_flex_values_vl

1542:
1543: -- SQL for Valueset type Independent
1544: CURSOR csr_value_set_ind(p_flex_value_id IN NUMBER) IS
1545: SELECT 'x'
1546: FROM fnd_flex_values_vl
1547: WHERE flex_value_id = p_flex_value_id
1548: AND enabled_flag = 'Y'
1549: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1);
1550: