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(+);