DBA Data[Home] [Help]

APPS.GCS_VALUE_SET_PKG dependencies on FEM_ENTITIES_B

Line 34: FROM fem_entities_b feb,

30: MERGE INTO fnd_flex_values ffv
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

Line 139: fem_entities_b feb,

135: SELECT gcr.child_entity_id,
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'))

Line 229: fem_entities_b feb

225: INTO l_hierarchy_id,
226: l_top_entity_id,
227: l_entity_display_code
228: FROM gcs_hierarchies_b ghb,
229: fem_entities_b feb
230: WHERE ghb.certification_flag = 'Y'
231: AND feb.entity_id = ghb.top_entity_id;
232:
233: SELECT flex_value_set_id