DBA Data[Home] [Help]

APPS.GCS_FEM_HIER_SYNC_PKG dependencies on GCS_HIERARCHIES_VL

Line 80: FROM gcs_hierarchies_vl ghv,

76: feb.entity_display_code
77: INTO l_hierarchy_name,
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

Line 313: gcs_hierarchies_vl ghv

309: l_entity_type,
310: l_hierarchy_name
311: FROM gcs_cons_relationships gcr,
312: fem_entities_attr fea,
313: gcs_hierarchies_vl ghv
314: WHERE gcr.cons_relationship_id = p_cons_relationship_id
315: AND gcr.hierarchy_id = ghv.hierarchy_id
316: AND gcr.dominant_parent_flag = 'Y'
317: AND gcr.child_entity_id = fea.entity_id