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_CONS_IMPACT_ANALYSIS_PKG dependencies on GCS_HIERARCHIES_B

Line 87: gcs_hierarchies_b ghb,

83: l_src_dimension_group_id,
84: l_tgt_calendar_id,
85: l_tgt_dimension_group_id
86: FROM GCS_CAL_PERIOD_MAPS gcpm,
87: gcs_hierarchies_b ghb,
88: fem_cal_periods_b fcpb
89: WHERE gcpm.SOURCE_CALENDAR_ID = fcpb.CALENDAR_ID
90: AND gcpm.SOURCE_DIMENSION_GROUP_ID = fcpb.DIMENSION_GROUP_ID
91: AND gcpm.TARGET_CALENDAR_ID = ghb.CALENDAR_ID

Line 464: gcs_hierarchies_b fhb,

460: --Extract Calendar Period Information
461: SELECT fcb.cal_period_id
462: INTO l_cal_period_id
463: FROM fem_cal_periods_b fcb,
464: gcs_hierarchies_b fhb,
465: fem_cal_periods_attr fcpa_start_date,
466: fem_cal_periods_attr fcpa_end_date
467: WHERE fhb.hierarchy_id = l_hierarchy_id
468: AND fcb.calendar_id = fhb.calendar_id

Line 797: gcs_hierarchies_b ghb

793: fem_cal_periods_attr fcpa,
794: gcs_entity_cons_attrs geca,
795: gcs_cal_period_maps_gt gcpmt,
796: fem_cal_periods_b fcpb,
797: gcs_hierarchies_b ghb
798: WHERE gcer.most_recent_flag = 'Y'
799: AND gcer.balance_type_code = p_balance_type_code
800: AND gcer.cal_period_id = gcpmt.target_cal_period_id
801: AND gcer.hierarchy_id = gcr.hierarchy_id