78: l_start_date,
79: l_top_entity_display_code
80: FROM gcs_hierarchies_vl ghv,
81: gcs_hierarchies_b ghb,
82: fem_entities_b feb
83: WHERE ghb.hierarchy_id = p_hierarchy_id
84: AND ghb.top_entity_id = feb.entity_id
85: AND ghv.hierarchy_id = p_hierarchy_id;
86:
162: 1,
163: NULL,
164: 'LOAD',
165: USERENV('LANG')
166: FROM fem_entities_b fev_p,
167: fem_entities_b fev_c,
168: gcs_cons_relationships gcr
169: WHERE gcr.hierarchy_id = p_hierarchy_id
170: AND gcr.parent_entity_id = fev_p.entity_id
163: NULL,
164: 'LOAD',
165: USERENV('LANG')
166: FROM fem_entities_b fev_p,
167: fem_entities_b fev_c,
168: gcs_cons_relationships gcr
169: WHERE gcr.hierarchy_id = p_hierarchy_id
170: AND gcr.parent_entity_id = fev_p.entity_id
171: AND l_start_date BETWEEN gcr.start_date AND NVL(gcr.end_date, l_start_date)