APPS.GCS_VALUE_SET_PKG dependencies on FEM_ENTITIES_ATTR

Line 35: fem_entities_attr fea

31: USING (SELECT feb.entity_id,
32: feb.entity_display_code,
33: decode(fea.dim_attribute_varchar_member,'C','Y','N') summary_flag
34: FROM fem_entities_b feb,
35: fem_entities_attr fea
36: WHERE feb.value_set_id = 18
37: AND fea.entity_id = feb.entity_id
38: AND fea.attribute_id = g_entity_type_attr_id
39: AND fea.version_id = g_entity_type_version_id

Line 140: fem_entities_attr fea

136: feb.entity_display_code child_entity_display_code,
137: fea.dim_attribute_varchar_member child_entity_type_code
138: FROM gcs_cons_relationships gcr,
139: fem_entities_b feb,
140: fem_entities_attr fea
141: WHERE gcr.hierarchy_id = p_hierarchy_id
142: AND gcr.parent_entity_id = p_entity_id
143: AND TO_DATE(p_eff_date,'DD-MM-YYYY') BETWEEN gcr.start_date AND NVL(gcr.end_date, TO_DATE(p_eff_date,'DD-MM-YYYY'))
144: AND gcr.dominant_parent_flag = 'Y'