APPS.QP_MODIFIER_UPGRADE_PVT dependencies on FND_FLEX_VALUE_SETS

Line 307: FROM FND_DESCR_FLEX_COLUMN_USAGES a , SO_ENTITIES b, fnd_flex_value_sets c

303:
304: CURSOR get_contexts_for_pattrs_cur(p_entity_id NUMBER) IS
305: SELECT nvl(a.DESCRIPTIVE_FLEX_CONTEXT_CODE,'Global Data Elements') descriptive_flex_context_code ,
306: b.ENTITY_CODE, a.COLUMN_SEQ_NUM, nvl(c.FORMAT_TYPE,'C') FORMAT_TYPE
307: FROM FND_DESCR_FLEX_COLUMN_USAGES a , SO_ENTITIES b, fnd_flex_value_sets c
308: WHERE a.DESCRIPTIVE_FLEXFIELD_NAME = 'PRICING_ATTRIBUTES'
309: AND a.APPLICATION_COLUMN_NAME = b.ENTITY_CODE
310: AND b.ENTITY_ID = p_entity_id
311: AND a.FLEX_VALUE_SET_ID = c.FLEX_VALUE_SET_ID(+);

Line 1350: FROM FND_DESCR_FLEX_COLUMN_USAGES a , fnd_flex_value_sets c

1346:
1347: SELECT a.COLUMN_SEQ_NUM, nvl(c.FORMAT_TYPE,'C')
1348: INTO x_qualifier_precedence, x_product_datatype
1349: --INTO l_precedence, x_product_datatype --modified by dhgupta for 2992566
1350: FROM FND_DESCR_FLEX_COLUMN_USAGES a , fnd_flex_value_sets c
1351: WHERE a.DESCRIPTIVE_FLEXFIELD_NAME = 'QP_ATTR_DEFNS_PRICING'
1352: AND a.APPLICATION_ID = 661 --(QP). Added for bug 5030757
1353: AND a.DESCRIPTIVE_FLEX_CONTEXT_CODE = v_product_context
1354: AND a.APPLICATION_COLUMN_NAME = v_product_attribute

Line 1405: FROM FND_DESCR_FLEX_COLUMN_USAGES a , fnd_flex_value_sets c

1401: BEGIN
1402:
1403: SELECT a.COLUMN_SEQ_NUM, nvl(c.FORMAT_TYPE,'C')
1404: INTO x_qualifier_precedence, x_qualifier_datatype
1405: FROM FND_DESCR_FLEX_COLUMN_USAGES a , fnd_flex_value_sets c
1406: WHERE a.DESCRIPTIVE_FLEXFIELD_NAME = 'QP_ATTR_DEFNS_QUALIFIER'
1407: AND a.APPLICATION_ID = 661 --(QP). Added for bug 5030757
1408: AND a.DESCRIPTIVE_FLEX_CONTEXT_CODE = v_product_context
1409: AND a.APPLICATION_COLUMN_NAME = v_product_attribute