APPS.GCS_CONS_IMPACT_ANALYSIS_PKG dependencies on FEM_CAL_PERIODS_B

Line 88: fem_cal_periods_b fcpb

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
92: AND gcpm.TARGET_DIMENSION_GROUP_ID = ghb.DIMENSION_GROUP_ID

Line 135: FROM fem_cal_periods_b fcpb,

131: gcs_utility_pkg.get_cal_period_details(p_cal_period_id,
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

Line 463: FROM fem_cal_periods_b fcb,

459:
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

Line 796: fem_cal_periods_b fcpb,

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
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

Line 1307: fem_cal_periods_b fcpb,

1303: gcer.cal_period_id
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