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 FEM_CAL_PERIODS_ATTR

Line 136: fem_cal_periods_attr fcpa_number,

132: l_cal_period_record);
133: SELECT fcpb.cal_period_id
134: INTO l_target_cal_period_id
135: FROM fem_cal_periods_b fcpb,
136: fem_cal_periods_attr fcpa_number,
137: fem_cal_periods_attr fcpa_year,
138: gcs_cal_period_map_dtls gcpmd
139: WHERE gcpmd.cal_period_map_id = l_cal_period_map_id
140: AND fcpb.calendar_id = l_tgt_calendar_id

Line 137: fem_cal_periods_attr fcpa_year,

133: SELECT fcpb.cal_period_id
134: INTO l_target_cal_period_id
135: FROM fem_cal_periods_b fcpb,
136: fem_cal_periods_attr fcpa_number,
137: fem_cal_periods_attr fcpa_year,
138: gcs_cal_period_map_dtls gcpmd
139: WHERE gcpmd.cal_period_map_id = l_cal_period_map_id
140: AND fcpb.calendar_id = l_tgt_calendar_id
141: AND fcpb.dimension_group_id = l_tgt_dimension_group_id

Line 177: FROM fem_cal_periods_attr

173: END IF;
174:
175: SELECT date_assign_value
176: INTO l_end_date
177: FROM fem_cal_periods_attr
178: WHERE cal_period_id = l_cal_period_id
179: AND attribute_id = l_end_date_attribute_id
180: AND version_id = l_end_date_version_id;
181:

Line 465: fem_cal_periods_attr fcpa_start_date,

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
469: AND fcb.dimension_group_id = fhb.dimension_group_id

Line 466: fem_cal_periods_attr fcpa_end_date

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
469: AND fcb.dimension_group_id = fhb.dimension_group_id
470: AND fcb.cal_period_id = fcpa_start_date.cal_period_id

Line 793: fem_cal_periods_attr fcpa,

789: gcer.hierarchy_id,
790: gcr.cons_relationship_id
791: FROM gcs_cons_eng_runs gcer,
792: gcs_cons_relationships gcr,
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

Line 1025: FROM gcs_entry_headers geh, fem_cal_periods_attr fcpa_start

1021: l_hierarchy_id,
1022: l_entity_id,
1023: l_bal_type_code,
1024: l_start_cp_end_date
1025: FROM gcs_entry_headers geh, fem_cal_periods_attr fcpa_start
1026: WHERE geh.entry_id = l_entry_id
1027: AND geh.start_cal_period_id = fcpa_start.cal_period_id
1028: AND fcpa_start.attribute_id = l_cal_period_attr
1029: AND fcpa_start.version_id = l_cal_period_version;

Line 1203: FROM gcs_entry_headers geh, fem_cal_periods_attr fcpa_start

1199: l_hierarchy_id,
1200: l_entity_id,
1201: l_bal_type_code,
1202: l_start_cp_end_date
1203: FROM gcs_entry_headers geh, fem_cal_periods_attr fcpa_start
1204: WHERE geh.entry_id = l_entry_id
1205: AND geh.start_cal_period_id = fcpa_start.cal_period_id
1206: AND fcpa_start.attribute_id =
1207: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')

Line 1308: fem_cal_periods_attr fcpa_end,

1304: FROM gcs_cons_eng_runs gcer,
1305: gcs_cons_eng_run_dtls gcerd,
1306: gcs_curr_treatments_b gctb,
1307: fem_cal_periods_b fcpb,
1308: fem_cal_periods_attr fcpa_end,
1309: gcs_cons_relationships gcr,
1310: gcs_entity_cons_attrs geca_parent,
1311: gcs_entity_cons_attrs geca_child
1312: WHERE gcer.cal_period_id = fcpb.cal_period_id

Line 1694: fem_cal_periods_attr fcpa_start,

1690: SELECT min(gcer.cal_period_id) cal_period_id,
1691: gcer.hierarchy_id hierarchy_id,
1692: min(fcpa_end.date_assign_value) end_date
1693: FROM gcs_cons_eng_runs gcer,
1694: fem_cal_periods_attr fcpa_start,
1695: fem_cal_periods_attr fcpa_end
1696: WHERE gcer.cal_period_id = fcpa_start.cal_period_id
1697: AND gcer.cal_period_id = fcpa_end.cal_period_id
1698: AND fcpa_start.date_assign_value >= p_eff_start_date

Line 1695: fem_cal_periods_attr fcpa_end

1691: gcer.hierarchy_id hierarchy_id,
1692: min(fcpa_end.date_assign_value) end_date
1693: FROM gcs_cons_eng_runs gcer,
1694: fem_cal_periods_attr fcpa_start,
1695: fem_cal_periods_attr fcpa_end
1696: WHERE gcer.cal_period_id = fcpa_start.cal_period_id
1697: AND gcer.cal_period_id = fcpa_end.cal_period_id
1698: AND fcpa_start.date_assign_value >= p_eff_start_date
1699: AND fcpa_end.date_assign_value <= p_eff_end_date

Line 1908: FROM gcs_entry_headers geh, fem_cal_periods_attr fcpa_start

1904: l_hierarchy_id,
1905: l_entity_id,
1906: l_bal_type_code,
1907: l_start_cp_end_date
1908: FROM gcs_entry_headers geh, fem_cal_periods_attr fcpa_start
1909: WHERE geh.entry_id = l_entry_id
1910: AND geh.start_cal_period_id = fcpa_start.cal_period_id
1911: AND fcpa_start.attribute_id =
1912: gcs_utility_pkg.g_dimension_attr_info('CAL_PERIOD_ID-CAL_PERIOD_END_DATE')