eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_FEM_HIER_SYNC_PKG dependencies on GCS_CONS_RELATIONSHIPS

Line 168: gcs_cons_relationships gcr

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)
172: AND gcr.dominant_parent_flag= 'Y'

Line 285: FROM gcs_cons_relationships gcr

281: SELECT gcr.parent_entity_id,
282: gcr.child_entity_id,
283: gcr.start_date,
284: gcr.end_date
285: FROM gcs_cons_relationships gcr
286: WHERE gcr.hierarchy_id = p_hierarchy_id
287: AND gcr.dominant_parent_flag = 'Y'
288: AND gcr.child_entity_id = p_child_entity_id;
289:

Line 311: FROM gcs_cons_relationships gcr,

307: l_child_entity_id,
308: l_start_date,
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